Monthly Archives: December 2008

UUID generation for PostgreSQL 8.3 on FreeBSD

Posted on 2008-12-21 by Andrew

A couple of weeks ago I whomped up a quick module in response to someone on IRC who was unable to get contrib/uuid-ossp working on FreeBSD (which turns out to be due to a nasty conflict between misc/ossp-uuid and libc). … Continue reading →

Posted in PlanetPG, Postgres | Comments Off on UUID generation for PostgreSQL 8.3 on FreeBSD

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

Hello world!

Posted on 2008-12-08 by Andrew

I have no idea if I want to keep a blog. So let’s see what happens, if anything.

Posted in Bloggery | 2 Comments