Little weekend hack - Native UUIDs in PostgreSQL
Check out the polarrose-postgresql-uuid project hosted at Google Code. It contains a simple native UUID implementation for PostgreSQL. I did this as an exercise but I’m considering to put this into production since it saves a lot of memory and disk space. A whopping 47% on tables that have an indexed uuid column.
My next PostgreSQL hack will be a native “faceprint” type combined with operators like distance() and average() so that we can do some faceprint experiments more easily at Polar Rose. Unfortunately that won’t be open source
Created
