External Stored Procedures Framework for MySQL

Antony Curtis (Blizzard Entertainment)
Architecture and Technology
Location: Ballroom C
Average rating: ***..
(3.50, 2 ratings)

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.

Photo of Antony Curtis

Antony Curtis

Blizzard Entertainment

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.

Comments

Picture of Antony Curtis
04/21/2009 5:18pm PDT

Presentation available at cyberkinetica.homeunix.net/...

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.