DBIx::Class (aka DBIC) for beginners

This video is in English.
Length: 21:39
Source: YAPC::EU 2012 on the 2012-08-20.
Speaker: Leo Lapworth (Ranguard)
If your not using an ORM (Object Relational Mapper) and are still writing SQL by hand, here's what you need to know. An introduction into DBIx::Class and some of the concepts and goodies you should be aware off. As some of the slides have small letters, you might want to follow the presentation while also looking at the slides.
  • Always make your tables plural
  • Start using utf8
  • CRUD - Create, Retrieve, Update, Delete
  • Use DBIC_TRACE=1 for debugging
  • Everything can be autogenerated for you, except the many_to_many relationship.