MySQL Forums
Forum List  »  Stored Procedures

Stored procedures utility library
Posted by: Giuseppe Maxia
Date: November 21, 2005 03:41AM

Hi all,
I need some brainstorming.

I am planning to release some stored procedures and functions as an utility library.
My idea would be to start a SourceForge project (or some other publicly available site) and put my stuff there, with an invitation to everyone to contribute bug fixes, enhancements, more functions, and so on.

For starting, I have routines to do the following:

- execute one command multiple times, with a counter;
- same as above, but with an additional command to execute before and after each command,
or with one to execute before all the commands and another one after all is finished;
- execute the same command for each table in a database, with optional filter;
- transform one table from MyISAM to Archive without need to manually fiddling
with the table structure;
- several methods to get the list of columns as a concatenated string from a table;
- a naive implementation of arrays for stored procedures, with push/pop/shift/unshift
capabilities.
- routines to create crosstabs.

My aim is to release such routines whith good documentation and a test suite, so that they are
usable, safe, and easily integrated with each other. Therefore I would start contributing these
routines as long as I write sensible documentation for them.

Before I begin. though, I would like to know if any such resource already exists.

Any comments would be welcome
Giuseppe

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored procedures utility library
5927
November 21, 2005 03:41AM
2790
November 21, 2005 04:39AM
2527
November 21, 2005 05:13AM
2691
November 21, 2005 08:00AM
2851
November 21, 2005 06:53AM
2756
November 21, 2005 08:06AM
2560
November 21, 2005 08:32AM
7941
November 23, 2005 11:24AM
2673
December 03, 2005 08:37AM
2549
November 28, 2005 02:26AM
2646
November 29, 2005 04:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.