Battling a Legacy Schema with DBIx::Class

Battling a Legacy Schema with DBIx::Class

By Lee Johnson aus London.pm
Datum: Freitag September 2, 2016 15:45
Dauer: 20 Minuten
Target audience: Mittel
Language: English
Tags: dbic perl5

Mehr Informationen gibt es auf der Seite des/der Vortragenden:

This talk aims to give/explain some lessons learnt and tips on using DBIx::Class with a legacy database schema.

An overview of DBIx::Class will be given, although this will not be in great detail and there is some expectation of knowledge of the basics of dbic

The basic skeleton of the talk is as follows:

- Who am i?
- Why DBIx::Class
- Legacy Schema
+ Grown organically
+ Poorly normalised
+ No relational constraints
+ Polymorphic relationships
+ Poor choice of data types
+ SQL Antipatterns
- Battling the above with DBIx::Class
+ Generating schema classes
+ Adding relationships
+ Solving joins on polymorphic relationships
+ Inflating columns
+ Fixing data types with filters
+ Virtual views and reports
+ Query tracing and profiling
- Questions?

Other topics touched upon may include:

- MVC
+ Thin controllers
+ Fat model

I expect the talk to last around 15 minutes, and with a Q&A at the end that should take it to the 20 minute mark. The full presentation and example code will available for view/fork/contribution on github.

Attended by: Markus Hechenberger (‎Hechi‎), Thomas Eisenbock (‎MyControl GmbH‎), Michael Kröll (‎pepl‎), Renee Bäcker (‎reneeb‎), Jozef Kutej (‎jozef‎), Wolfgang Schemmel (‎Perleone‎), Elmar Heeb (‎esh‎), David Schmidt (‎davewood‎), Dirk Deimeke,