Being Better Isn't Always Best! PostgresSQL

In low cost web hosting you really only have two main choices of database, MySQL on Linux/Windows and SQL Server (200,2005 and now 2008) on Windows (MS Access is on the way out). There is a lesser known third one that like MySQL is open source: PostgreSQL. I'm not considering the big expensive databases like Oracle or DB2.

PostgresSQL seemed for some years to be well ahead of MySQL. It was started over 15 years ago as a spin-off from Ingres and had transactions, views, functions, triggers, stored procedures well long before MySQL but never achieved the popularity that MySQL did in LAMP/WAMP. Early attempts to commercialize PostgresSQL foundered until the last few years and the commercial versions are now sold by EnterpriseDB Ltd while the open source version continues. This is no toy but Enterprise quality code so if you are looking for a database to use in your applications, consider PostgresSQL. I've added a link to PostgresSQL in the C code library.

• Link to C Code Library