---
title: "This Week's PostgreSQL News (#88)"
publication: "Postgres Weekly"
issue: 88
published_at: "2015-01-14"
canonical_url: "https://postgresweekly.com/issues/88"
---

Postgres Weekly Issue 88 - January 14, 2015

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/88)**Postgres Weekly****Issue 88**
January 14, 2015[PostgreSQL 9.4 Now Available on Heroku](https://blog.heroku.com/archives/2015/1/8/postgres-9-4-on-heroku?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 has been a long time coming, it feels we’ve been waiting for it since July, especially for JSONB. Now that it’s here you can get hands on with it directly on Heroku by simply clicking a button._Heroku_[SQL, Scaling, and What's Unique About Postgres](http://citusdata.com/blog/90-sql-scaling-and-whats-unique-about-postgres?utm_source=postgresweekly&utm_medium=email)Get an overview of the roots of SQL, how databases scale, and a look at why Postgres is a great candidate for much of this._Ozgun Erdogan_[Postgres 9.5 Feature Highlight: New WAL Format](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-new-wal-format/?utm_source=postgresweekly&utm_medium=email)_Michael Paquier_[It’s a New Year! What Are Your Postgres Database Resolutions?](http://www.enterprisedb.com/ahc?utm_source=cooperpress=nl=tahcjan14?utm_source=postgresweekly&utm_medium=email)Have you resolved to fix that nagging [performance problem](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=cooperpress=nl=btptmjan14) once and for all? Are you prepared for data growth in 2015? Now's the time to do a quick tune up. Evaluate your Postgres database performance with a quick [Architectural Health Check](http://www.enterprisedb.com/ahc?utm_source=cooperpress=nl=bahcjan14) and ensure your system is optimally configured and tuned as you start the year._EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://www.enterprisedb.com/ahc?utm_source=cooperpress=nl=tahcjan14?utm_source=postgresweekly&utm_medium=email)[SQL Is Your Friend, Part 3](http://cookingco.de/2014/12/19/sql-is-your-friend-part-3/?utm_source=postgresweekly&utm_medium=email)Part 3 of an awesome series on some of the great things about SQL digs into subqueries and common table expressions or CTE’s, think of them as a view within a single query. They can be both powerful and make things more readable._Barrett Clark_[Actually Using the Database: Writing a Haskell API Server](https://bendyworks.com/actually-using-the-database/?utm_source=postgresweekly&utm_medium=email)Some developers lean as heavily on their ORM as they can, others find a balance between using one or dropping to SQL where possible. But what if you were to start with only SQL? Here’s a take through the lens of heavily leveraging your database, highlighting using pgcrypto for authentication._Jon Childress_[Publish/Subscribe (Pub/Sub) with Postgres and Node.js](http://voxpelli.com/2015/01/pubsub-with-postgres-and-node-js/?utm_source=postgresweekly&utm_medium=email)Whether it’s a realtime application of you’re just offloading work to background workers pub/sub has a place in your app, and it also has a home in Postgres with listen/notify. Here’s a great example of using it with Node._Pelle Wessman_[django-pgcrypto-fields: Encrypted fields dealing with pgcrypto postgres extension.](https://github.com/incuna/django-pgcrypto-fields?utm_source=postgresweekly&utm_medium=email)If you need to encrypt something and want a simple and expedient way, pgcrypto within your database can work great. Here’s a package that helps make this easier within Django._Incuna Ltd_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)