Perl Stored Procedures for MariaDB
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.