Postgres Weekly Issue 88
January 14, 2015
PostgreSQL 9.4 Now Available on Heroku
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
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
Michael Paquier
It’s a New Year! What Are Your Postgres Database Resolutions?
Have you resolved to fix that nagging performance problem 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 and ensure your system is optimally configured and tuned as you start the year.
EnterpriseDB  Sponsored
SQL Is Your Friend, Part 3
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
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
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.
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