Issues » 15

Read this issue on the Web
Postgres Weekly Issue 15
June 19, 2013
Postgres - A Tipping Point?
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.
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2013 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens