PostgreSQL is a powerful, open source object-relational database system.
• fully ACID compliant
• full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages)
• includes most SQL 2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP
• supports storage of binary large objects, including pictures, sounds, or video
• multi-Version Concurrency Control (MVCC)
• Highly customisable
A&H use case 1 description:
The “Great Britain Historical Geographical Information System (GBHGIS)” has used PostgreSQL to store the geographically-located historical statistics for Great Britain.
PostgreSQL Global Development Group
Software/programming languages used:
FileMaker, MySQL, SQLite, Firebird