Cdbi cookbook

How to, why to, tips and tricks:


 * common problems
 * Class::DBI and Template Toolkit
 * using Class::Date to handle dates with ease
 * using DateTime another way of working with dates
 * complex many to many with a complex many to many example
 * setting system date fields (or equivalent)
 * Oracle specific stuff
 * Working With Oracle Date Fields
 * Setting Session Globals
 * setting default values
 * using transactions (a.k.a. atomic updates)
 * using with mod_perl
 * working with blobs
 * case insensitive searches
 * order by multiple columns
 * see all SQL
 * edit data in a text editor
 * delete by setting deleted column to not null
 * confirm password at registration
 * directly execute SQL
 * using joins
 * load file from STDIN
 * query aggregates
 * deleting related objects
 * conflicting updates
 * self-referencing tables
 * searching for NULL and IS NOT NULL
 * working with triggers
 * using multiple databases
 * re-using legacy DBI handles
 * overriding autogenerated accessors
 * get a database handle from your Class::DBI object
 * transform SQL
 * select distinct
 * parent child relationships
 * overriding retrieve_all for specific ordering
 * storing encrypted passwords
 * versioning with two tables
 * implementing an object factory, or using multiple classes for one table
 * inflating and deflating storable data
 * turning a row id into an accessor, or how to turn tables on their side

To-Do

 * retrofitting over an existing schema