A Tour of External Language Stored Procedures for MySQL

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 plug-ins, writing stored procedures and functions, with ideas for applications and their utility.

This presentation includes a tour of the actual source code, highlighting the big picture. The audience will see the low impact of the main-line server code, the simplicity of writing plug-ins for new languages and the ease of using the language plug-ins already developed. This is an exciting new feature preview for MySQL. All demonstrations are with live running examples which everyone can try for themselves: No mockups, no screen-shots.