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
Language:

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.