"World's most advanced open source database"
Post - greS - Q - L
- 1970s (Berkley) Interactive Graphics and Retrieval System, or “Ingres”.
- 1980s, "post-Ingres" shortened to Postgres.
- Open-sourced 1996
- 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
- 18 procedural languages (PL/V8)
- XML data type (XPath queries)
- hstore - key/value store
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
- Dataclips
- Fork
- Follow
- Connect from anywhere