Postgresql

"World's most advanced open source database"

Post - greS - Q - L

  • Linux (Debian based):
    apt-get install postgresql-9.2
  • OSX: http://postgresapp.com
  • Windows: binary from http://postgresql.org
Has most of the features of commercial solutions but is GPL

Recent major release
on September 10, 2012

Big performance gain with new visibility map, prevents real tuple "visits"
Cascading, streaming replication
=# SELECT row_to_json(demo)       FROM demo; row_to_json -------------------------------- {"username":"john","posts":121} {"username":"mickael","posts":215}
=# SELECT * FROM my_range WHERE period && '[2012-01-03 00:00:00,2012-01-03 12:00:00]'; period -------------------------------- ["2012-01-01 00:00:00+01","2012-03-01 00:00:00+01"]
SQL Database-as-a-Service