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
- 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

Options: ReplyQuote

Written By
Stored procedures utility library
November 21, 2005 03:41AM
November 21, 2005 04:39AM
November 21, 2005 05:13AM
November 21, 2005 08:00AM
November 21, 2005 06:53AM
November 21, 2005 08:06AM
November 21, 2005 08:32AM
November 23, 2005 11:24AM
December 03, 2005 08:37AM
November 28, 2005 02:26AM
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.