A Very Good Day For Postgres: Postgres.app, Postgres Guide, and Schemaless SQL
Posted by Mattt
Today has been a very good day for Postgres.
We here at Heroku love Postgres, and we aren't afraid to show it. Here's how three different Herokai showed their PG love in three awesome ways in the last 24 hours:
Postgres.app is the easiest way to run PostgreSQL on the Mac. Just open the app, and you have a server up and running with Postgres 9.1 and PostGIS 2.0. PostgreSQL has not been the easiest things to install--especially for new developers--so we see Postgres.app as an important step in making the world's best database more accessible to everyone. Postgres.app was created by Mattt Thompson, and launched in beta today. It will soon be available as a free download in the Mac App Store.
From making Postgres easier to install to making it easier to understand, Craig Kerstien's Postgres Guide made its debut on the Hacker News front page to much acclaim. Craig's guide outlines the best features of Postgres in detailed, well-written prose that's easy to understand and a joy to read. It's still early in its development, but there are already some great gems in there, like the chapter on Views, and the articles about Indexes and Execution Plans.
Also spreading knowledge was Will Leinweber, who delivered his "Schemaless SQL" talk this afternoon at RailsConf in Austin. It was a veritable salvo of enthusiasm and insight; the audience hung on every word as Will demonstrated the power and flexibility of hstore. The often disparate worlds of RDBMS and NoSQL, united as one: it's a beautiful thing.