Perl Stored Procedures for MariaDB

New Features
25 April 1:50pm - 2:40pm @ Ballroom E

MySQL has had Stored Procedures for a long time but since it is Standards based, it is quite restrictive in what may be done with it. Writing Stored Procedures in Perl has a lot of advantages, partly owing to the extensive available CPAN library, and would allow more sophisticated processing to be performed from within the database.

Writing Perl Stored Procedures is as simple as writing a standard Perl module and accessing the database is as straightforward as using the existing Perl DBI API.

With greater flexibility than the in-built SQL Stored Procedure, it is possible to process more data, faster, directly within MariaDB, returning only the data that is needed for the application.


Antony Curtis
Senior Software Engineer, LinkedIn Corp
Antony Curtis is an advocate of Open Source software and long-time user of alternative operating systems. His involvement with MySQL spans more than 10 years and he was a software developer for MySQL AB from 2003 to 2008.