Simon Willison’s Weblog

Subscribe

Stored procedures in MySQL?

10th July 2003

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.

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

Next: Storing Dates in MySQL

Previous: Clearout

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