Issues » 33

Read this issue on the Web
Postgres Weekly Issue 33
October 23, 2013
Featured
Progress on Implementing Parallelism in Postgres
Parallelism has been desired within Postgres for a few years now. Fortunately one of the core contributors has been plugging away on it recently. Get an update directly from him here on progress.
Robert Haas
Rapid Schema Development with PostgreSQL
Postgres has had some flexibility with hstore (a key value column type) for some time, now its JSON is richer, and with PLV8 it has full JavaScript support. Andrew Godwin recently highlighted all this and how you can move faster with Postgres in many cases at Allyourbaseconf.
Andrew Godwin
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
PostgreSQL Autonomous Transactions
In addition to parallelism, autonomous transactions are one of those features missing within Postgres. Fortunately you can get that functionality without too much extra effort with PL/Proxy
Dimitri Fontaine
Using Custom Composite Types in PostgreSQL
Composite types can offer you a bit more power within Postgres and can often be quite easy to work with. Here’s a specific look at using them specifically within PL/pgsql.
Pavel Stehule
post_json: A Document Database by Combining Features of Ruby, ActiveRecord and PostgreSQL with PLV8
Webnuts
node-pg-query-stream: Query results from node-postgres as a readable (object) stream
Query results from node-postgres as a readable (object) stream
Brian C
E-Maj 1.1.0 released
If you need logging around various groups of tables for auditing and an ability to recover from them heres an extension to help with just that.
PostgreSQL news
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