PostgreSQL

Purpose:

PostgreSQL is a powerful, open source object-relational database system.

Features:

• 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.

Creator:

Michael Stonebraker

Publisher:

PostgreSQL Global Development Group

Data capture:

Manual input and transcription

Specifications:

PHP

eXtensible Markup Language (XML)

Perl

Python

Java