| 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 |
|
| 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 |
|
|
|
|