Catalyst, DBIx::Class and PostgreSQL
By Matt S Trout (mst) from northwestengland.pm, dahut.pm, drinkers.pm, lgbt.pm
Date: Saturday, 29 November 2008 11:05
Duration: 40 minutes
The tale of building an app with a moderately complex DB schema and strict performance requirements on the single most complex query in the application, mixing and matching straightforward DBIx::Class ORM code to automate away the simple stuff, postgres views and triggers to create a transparent OODB-style setup using multiple table inheritance and to allow for complex queries to be optimised at the database level without the ORM getting in the way, and how we mixed the two together to create an app that not only meets the performance requirements set out at the start of the project but substantially exceeds them, and is still fast to add features to and easy to maintain.
Attended by: Nicholas Clark, Gianni Ceccarelli (dakkar), Jody Belka (knewt), Leo Lapworth (Ranguard), Andrew Ford, Adam Trickett (ajt), Tim Bunce, Joel Bernstein (joel), James Morris, Michele Beltrame (arthas), Stan Sawa, richard Huxton, Glen Scott, Gordon Irving, Ian Norton (idn), Neil Hemingway (neilh),