Postgres Weekly Issue 15: June 19, 2013

Postgres Weekly

Issue 15
June 19, 2013

Featured

PostgreSQL is seeing broader and broader adoption from small hobby projects to larger enterprises. EnterpriseDB CEO discusses if its finally at a tipping point and provides some great detail on why. If you're trying to convince your company to switch hopefully you find what you're looking for in here.

Introducing PG Commander

If you're a Mac user and looking for Sequel Pro for Postgres your wait may now be over. While it isn't Sequel Pro, here's a new GUI tool specifically designed for Postgres. If psql isn't your flavor give this a spin.

From our sponsor

Heroku Postgres - Fully managed Postgres on EC2

There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.

The rest

More about JavaScript and PostgreSQL

A great roundup of several of the various JavaScript and Postgres sources that have surfaced over the recent months. If you want to learn more about taking advantage of JavaScript inside your database this is a great place for it.

PostgreSQL Functional Indexes

In case you missed the post a few weeks ago on functional indexes here's a good one to highlight how powerful and useful they are within Postgres.

Explaining your PostgreSQL data

While a bit lightweight here's a post from the myself, @craigkerstiens, that shows a few good resources for understanding the execution plans within PostgreSQL.

How to Generate Recurring Events in the Database

If you're working with scheduling events within your database, what seems like a simple exercise can be come a surprising difficulty when worried about performance as your data grows. Here's a great example that highlights some good steps and practices.

Postgres Database Tuning

While targeted at Heroku Postgres databases, here's a great article that highlights the overarching view of vacuum, auto-vacuum, and how you show maintain it within PostgreSQL... whether on Heroku or on your own.