Issues » 10

Read this issue on the Web
Postgres Weekly Issue 10
May 15, 2013
PostgreSQL 9.3 Beta 1 Released
Postgres 9.3, like many other releases before it, is shaping up to be a great release and the beta is now here. Get started with the beta to take advantage of materialized views, writable foreign data wrappers, improved JSON support via new operators, and of course much more.
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
Quickly Migrate A DB From MySQL To Postgres
For the few of you still on MySQL and hoping to get off here's a simple but straightforward guide on how you can get migrated. It also has a good callout to some more complicated options for those that need zero downtime migrations.
Deploying PostgreSQL on Amazon EC2: A Case Study
If you're running your own amazon instance especially on EC2 theres many gotchas that can occur. Here's a case study from OmniTI so you can take advantage of their lessons learned from running on top of Amazon.
Database Insight with pg-extras
If you're running on Heroku pg-extras is a CLI plugin that provides extra commands for the CLI to give you more insight. Even if not on Heroku you can take a look at the github repo for a great set of queries that can be beneficial to you.
Tagging With ActiveRecord and Postgres
Tags are a common part of any application, take a look at how you can take advantage of them natively within Rails and Postgres.
Introduction to PostgreSQL Arrays, Basic Concepts and Normalization Considerations
Postgres 9.3 Feature Highlight: Parallel 'pg_dump'
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