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

Postgres Weekly 100   . 

[Read this on the Web](http://postgresweekly.com/issues/100) 

[Postgres Weekly](http://postgresweekly.com) Issue 100 — April 8, 2015     

[A 5 Minute Video Introduction to pgcli](https://vimeo.com/124125257?utm_source=postgresweekly&utm_medium=email)pgcli is an awesome alternative Postgres command line interface with auto-completion and syntax highlighting (although I personally find psql [awesome on its own](http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/)). Amjith Ramanujam#video [dump_fdw: A Foreign Data Wrapper for Postgres Dump Files](https://github.com/MeetMe/dump_fdw?utm_source=postgresweekly&utm_medium=email)Provides the ability to query data directly from files in Postgres’ custom dump format. Currently a prototype that’s not recommended for production use. MeetMe#code [Postgres Skills are in Demand - Add to your skill set and get certified](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tComboApr07)4000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with Comprehensive PostgreSQL training. Join a live on-line training session next week with Bruce Momjian and get certified in PostgreSQL Administration. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/a656dc18.jpg)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tComboApr07) [Postgres's Publish-Subscribe Features Made Better with JSON](http://blog.andyet.com/2015/04/06/postgres-pubsub-with-json?utm_source=postgresweekly&utm_medium=email)Postgres’ wide array of features become even more fun when you bring them together. In this case, the popular JSON datatype gets coupled with pub-sub from directly in your database, or to Postgres listen-notify. Nathan Fritz [HOWTO Use JSON Functionality in PostgreSQL](http://stormatics.com/howto-use-json-functionality-in-postgresql/?utm_source=postgresweekly&utm_medium=email)The latest in the long line of overviews on using JSON in Postgres. This one covers the basics of inserting data but also filtering and querying it as well. Umair Shahid [pg_rewind in PostgreSQL 9.5](http://hlinnaka.iki.fi/2015/03/23/pg_rewind-in-postgresql-9-5/?utm_source=postgresweekly&utm_medium=email)Adding to the list of features which will be available in Postgres 9.5 comes pg_rewind. As the name suggests this will let you re-wind some of your WAL, which can be especially handy as highlighted in this post for anyone running an HA setup. Heikki Linnakangas [Waiting for 9.5 – Add Support for Index-Only Scans in GiST](http://www.depesz.com/2015/04/05/waiting-for-9-5-add-support-for-index-only-scans-in-gist/?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 development is well underway with new features landing each week. Here’s a look at further flushing out the useful-ness of the awesome GiST index type. Hubert depesz Lubaczewski [Django 1.7 Database Migrations Done Right](https://markusholtermann.eu/2014/09/django-17-database-migrations-done-right/?utm_source=postgresweekly&utm_medium=email)If you’ve used Django for any time you’re probably familiar with ‘South’. Now migrations are fully baked in here’s a guide for everything you need to know to handle them in a safe way for your app. Markus Holtermann [Reactive Postgres with Play Framework & ScalikeJDBC](http://www.jamesward.com/2015/04/07/reactive-postgres-with-play-framework-scalikejdbc?utm_source=postgresweekly&utm_medium=email)Want all your relational data backed by a safe data store in Postgres, while gaining some of the flexible non-blocking nature you often see with NoSQL data stores? Here’s an answer for when using Postgres with the Play framework. James Ward [Full Stack Developer at AlphaSights (New York, NY)](http://engineering.alphasights.com/?utm_source=postgresweekly&utm_medium=email)Write high quality and maintainable code. Be trusted to act autonomously and influence process/workflows, product direction, and technology choices. Work in a project team with two-week iterations. AlphaSights#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/100) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK