PostgreSQL is an advanced open source relational database system that I have had the plausere of working with for many years. Here is some resources:

Global unique ID creation (GUID)

This C-function can be loaded into the backend to create globally unique identifiers. It consists of a Linux implementation of the Microsoft Windows CoCreateGUID function that creates a 128-bit globally unique ID and a wrapper that uses a number system with base 64 to obtain a string with 22 characters. This last code is provided by IAI. This creates a GUID that can be used in the IFC standard but obviously has many other uses in PostgreSQL if you need to create ID's that is unique across databases.

Updated 21.03.2006 with a much better build script

Download binary (linux) and source

Updated: Tuesday 21 March 2006 08:48