Schedule - PGConf.EU 2013

Epic fails in the RDBMS world

Date: 2013-11-01
Time: 09:30–10:20
Room: Earlsfort
Level: Beginner

Entertainment is important in this speech - or should i say infotainment? The serious subjects of placing products on the ACID-continuum and the (dis)advantages of breaking RDBMS principles are illustrated by firsthand horror-stories from my 12+ years as a DBA. When will things break when you rub against the RDBMS-framework, such as choosing a wrong data-type, inserting several values in one column, the EAV model or disabling referential integrity are told with rolling eyes anecdotes. What are the dangers of not knowing the RDBMS rules? Although there will be references to Postgresql functionality and parameters, the lessons from this fun speech are applicable to all RDBMS.

This speech will be accompanied with a reader with further examples.

"A wise man learns from the mistake of others. A fool of his own."