Monthly Archives: December 2008

UUID generation for PostgreSQL 8.3 on FreeBSD

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

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!

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

Posted in Bloggery | 2 Comments