The integration of Business intelligence and logic within the database has been a long requested feature for MySQL. With version 5.0, MySQL delivered a stored procedure implementation and here we extend it to provide general support for external language stored procedures.
We detail the philosophy and design of the external language stored procedure framework and its implementation within the server and libraries. We then also detail how an external language plug-in is written using the simple skeleton plug-in which exercises the basic interfaces between the server and external stored procedures.
Demonstrations using the already developed plug-ins, including an overview of the implementation for the simple XML-RPC and the more sophisticated Java and Perl plug-ins. A simple guide on how to convert your existing UDFs into stored routines with a more powerful and complete API.
Antony Curtis is an advocate of Open Source software and long-time user of alternative operating systems. His involvement with MySQL spans 10 years and he was a software developer for MySQL AB from 2003 to 2008. He currently lives in Los Angeles, working for Google Inc.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.