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: Neil Hemingway (neilh), Nicholas Clark, Gordon Irving, Adam Trickett (ajt), richard Huxton, Glen Scott, Michele Beltrame (arthas), James Morris, Gianni Ceccarelli (dakkar), Ian Norton (idn), Tim Bunce, Stan Sawa, Leo Lapworth (Ranguard), Jody Belka (knewt), Joel Bernstein (joel), Andrew Ford,