Category Archives: Peeves

The Rule Challenge

Posted on 2010-06-21 by Andrew

I’ve made this challenge on IRC several times, and I think on the mailing lists too, but I’m putting it up here for reference. I’m not a fan of rules. I’ve used them in production code in the past, though … Continue reading →

Posted in Peeves, PlanetPG, Postgres | 15 Comments

On Normalization

Posted on 2008-12-08 by Andrew

People have funny ideas about database normalization. What normalization is not: creating an (id,value) table for every single piece of data is not normalization using surrogate keys for everything is not normalization a way to improve performance (though it sometimes … Continue reading →

Posted in Peeves, PlanetPG, SQL | Comments Off on On Normalization