Perl-Powered Extensions to MySQL: deferrable constraints and nested transactions

Presented by Len Budney

Abstract

The DBMS is normally tasked with insuring data integrity, but no DBMS provides a complete solution in this area. Triggers are often used to fill the gaps, but they don't work in all situations. Two important features needed by a modern DBMS, and not provided by MySQL, are nested transactions and deferrable constraints--the ability to defer constraint-checking until commit time. Both of these features can be implemented at the Perl layer, using existing MySQL features and Class::DBI's much richer system of triggers.

Details

Time: 10:30 AM
Length: 45 minutes
Room: Socialtext