MySQL Forums :: Stored Procedures :: Stored procedures utility library


Advanced Search

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 5050 Giuseppe Maxia 11/21/2005 03:41AM
Re: Stored procedures utility library 2425 Beat Vontobel 11/21/2005 04:39AM
Re: Stored procedures utility library 2163 Giuseppe Maxia 11/21/2005 05:13AM
Re: Stored procedures utility library 2254 Beat Vontobel 11/21/2005 08:00AM
Re: Stored procedures utility library 2343 Roland Bouman 11/21/2005 06:53AM
Re: Stored procedures utility library 2351 Giuseppe Maxia 11/21/2005 08:06AM
Re: Stored procedures utility library 2145 Roland Bouman 11/21/2005 08:32AM
Re: Stored procedures utility library 7112 Jay Pipes 11/23/2005 11:24AM
Re: Stored procedures utility library 2245 Mike Kruckenberg 11/29/2005 10:36PM
Re: Stored procedures utility library 2149 Giuseppe Maxia 12/03/2005 08:37AM
Re: Stored procedures utility library 2195 Giuseppe Maxia 11/28/2005 02:26AM
Re: Stored procedures utility library 2260 Jan Kneschke 11/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.