PGCon2008 - Final - we hope

PGCon 2008
The PostgreSQL Conference

Robert Treat
Day Tutorials - second day (2008-05-21)
Room Fauteux 147B
Start time 13:00
Duration 03:00
ID 97
Event type workshop
Track Tutorial
Language en

Database Anti-Patterns

Everyone else is doing it wrong, why can't we?

Many common solutions used in the world of database design go beyond sub-optimal to downright awful. Many times these pattern are carried over from early years of database design work, or learned from working on poorly implemented solutions. This talk we discuss many of the common faux pas, focusing not only on the bad, but hopefully providing better solutions to use in their place.

We have all seen certain patterns used over and over again in database design, but sadly many of the common ones tend not to be best practice. In this talk we will cover many of the most common database "anti-patterns", highlighting why they are bad, talk about ways to overcome them, and maybe even note a few cases where (gasp) you might have to use them.