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 […]
Glassfish and Derby and PostgreSQL
In my last post I gave a link to instructions for setting up a PostgreSQL database connection pool in Glassfish. Those instructions had a note attached about a mismatch between sequence names generated by PostgreSQL and Glassfish for serial
Glassfish and PostgreSQL
For my current EJB3 project I’m using Glassfish with the (built-in) Derby database. That setup works really well for development.
In production we’re going to use PostgreSQL 8.1, which is one of the most sophisticated and performant open source databases available. Googling for more information about Glassfish and PostgreSQL turned up a couple of good links.
The […]