Feed Sign in with OpenID OpenID

Simon Willison’s Weblog

Stored procedures in MySQL?

Via Sam Buchanan, it looks like MySQL might get stored procedure support soon in a big way:

Brian Aker, fresh on his new job as Senior Architect at MySQL, shocked the world (or, at least, me) when he announced that he’d embedded Perl in MySQL and was using it for stored procedures a couple of years ago. Of course, it did segfault rather often. Fortunately, it’s highly mature now. In his talk on “Making MySQL Do More”, Brian showed the embedded function API. You can write new functions for MySQL in Perl, Python, PHP, and Java.

Posted 10th July 2003 at 11:24 pm

This is Stored procedures in MySQL? by Simon Willison, posted on 10th July 2003.

View blog reactions

Next: Storing Dates in MySQL

Previous: Clearout

4 comments

  1. David Sklar, author of the O'Reilly PHP Cookbook, has the start of the same for PHP: http://www.sklar.com/page/article/myphp - believe this is now being controlled / released through PEAR::PECL but looking at the PHP CVS it's still on version 0.1

    Harry Fuecks - 11th July 2003 10:20 - #

  2. According to MySQL AB's web site, stored procedures are planned for version 5.0. That's what I find so exciting about Brian Aker's work: they're available now if you want them.

    Sam Buchanan - 11th July 2003 14:50 - #

  3. From which version of MySql are stored procedures supported?Can you send me details of the available versions and their features?

    Sanket - 19th February 2004 06:08 - #

  4. Stored procedure support is added with release 5 of MySQL. The PERL stuff is in a way a bit of red herring as its been possible to write functions in MySQL with C for some time. However it should be noted that these are simple functions which have no ability to access the data other than what you pass in. With Version 5 full support of both procedures and functions is included, this will allow access to data via standard SQL select into clause and also basic cursor processing.

    Andrew Gilfrin - 17th January 2005 09:21 - #

Comments are closed.

Previously hosted at http://simon.incutio.com/archive/2003/07/10/mysqlStoredProcedures

A django site