PostgreSQL

Created 16th March, 2008 13:09 (UTC), last edited 16th March, 2008 13:30 (UTC)

PostgreSQL (or Postgres for short) is an excellent open source database. It is a fully ACID compliant cross-platform RDBMS which has a number of features that make it very attractive for use with FOST.3™ applications. Amongst these are:

  • Unicode support
  • Cross-platform with a cross-platform access API, libpqxx.
  • Lockless isolation which means no livelocking or deadlocking problems between transactions.
  • Good support for read transactions.
  • Table inheritance which mirrors the way that object-oriented polymorphism is done within the FOST.3™ O/RM layer.
  • Permissive license which means we can distribute the database server with FOST.3™ applications.

Pages

Blog entries

1
Concurrency and isolation
2
Updated 1 row, but no change in the database
3
Running Postgres for development on Oneiric
4
Django 1.8, Django Slumber and Django Async