Issues » 30

Read this issue on the Web
Postgres Weekly Issue 30
October 2, 2013
Exploring Query Locks in Postgres
Ever been confused on how MVCC or locks work in Postgres? This is a great deep dive into how it all works and how you can take advantage of the functions to investigate your database further.
Manuel Kniep
Announcing PostgreSQL Studio 1.0
An open-source, web-based GUI for PostgreSQL. It allows users to manage and query their database from a browser. Version 1.0 of PostgreSQL Studio is distributed under the PostgreSQL License.
PostgreSQL Blog
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
From PG Open 2013: The Postgres Optimizer
The Postgres Optimizer is a both elegant and mysterious part of PostgreSQL. Robert Haas gave a talk on this at Postgres Open, you can grab slides here or check out this write-up on his talk.
Extra JSON Functions Needed
The JSON functions available in Postgres 9.3 make the JSON datatype as useful as ever. With that said there’s always room for improvement, here’s a call for input from the creator for what additional functions that would make it even better.
The Power of Enums
Enums while common at other times in languages aren’t an overly used feature in databases. Yet they can be incredibly powerful as demonstrated here.
Relatabase - Using Postgres Arrays with Rails 4
Few applications don’t take advantage of arrays, Postgres has had support for arrays for years as well. Now you can work with them natively from Ruby on Rails.
And what about pg_cron with background workers?
Background workers in PostgreSQL 9.3 make managing background jobs as easy as ever directly within Postgres. Here’s a dive into the concept of cron within Postgres and how it may look.
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