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

Postgres Weekly 97   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 97 — March 18, 2015     

[Stopping Expensive Queries Before They Start](http://adpgtech.blogspot.com/2015/02/stopping-expensive-queries-before-they.html?utm_source=postgresweekly&utm_medium=email)If you’ve ever run a query only to wait and realize you’re slowly bringing your database to a halt because of what’s happening under the covers, this may help. This module prevents certain queries from running if their query plans meet certain criteria. Andrew Dunstan [Registration for PGConf US 2015 Closing Soon](http://www.postgresql.org/about/news/1577/?utm_source=postgresweekly&utm_medium=email) PostgreSQL.​org#news [GraphpostgresQL: GraphQL for Postgres](https://github.com/solidsnack/GraphpostgresQL?utm_source=postgresweekly&utm_medium=email)GraphQL is a data querying language designed to describe the complex, nested data dependencies of modern applications. Essentially, a graph interface to relational data. Jason Dusek#code [Resolve Database Performance Issues Quickly](https://www.appdynamics.com/freetrial?utm_source=cooperpress&utm_medium=sponsorship&utm_campaign=postgres%20weekly&utm_content=resolve%20database%20performance%20issues%20quickly&utm_term=)AppDynamics' self-learning platform allows you to analyze actual database performance and detect anomalies automatically. It takes the guesswork out of defining optimal performance. Installs in Minutes. [Start Free Monitoring](https://www.appdynamics.com/freetrial?utm_source=cooperpress=sponsorship=postgres%20weekly=resolve%20database%20performance%20issues%20quickly=) AppDynamics#sponsored[![\](https://copm.s3.amazonaws.com/0718a665.png)](https://www.appdynamics.com/freetrial?utm_source=cooperpress&utm_medium=sponsorship&utm_campaign=postgres%20weekly&utm_content=resolve%20database%20performance%20issues%20quickly&utm_term=) [Postgres Array and Hstore Column Reference](http://honeyco.nyc/blog/postgresql-array-and-hstore-column-reference/?utm_source=postgresweekly&utm_medium=email)If for some reason you’re not yet on Postgres 9.4 and therefore able to take advantage of JSONB, there are still some great flexible data options available. The array and hstore datatypes, in particular, can give you some flexibility in your schema. Quinn Shanahan [Interacting with JSON and JSONB](http://bonesmoses.org/2015/03/13/pg-phriday-interacting-with-json-and-jsonb/?utm_source=postgresweekly&utm_medium=email)If you haven’t gotten to play with the new JSONB (in case your wondering B is for ‘better’… ;-)) in Postgres, here’s a look at some of the basics. Learn how to search for certain keys, interact with text within the object, and more. Shaun M.​ Thomas [Fast Postgres from .NET](https://blog.dsl-platform.com/fast-postgres-from-dotnet/?utm_source=postgresweekly&utm_medium=email) Rikard Pavelic [Using Temporary Tables in PostgreSQL with Rails](http://blog.honeybadger.io/using-temporary-tables-in-postgresql-with-rails/?utm_source=postgresweekly&utm_medium=email)Ever needed an intermediary when trying to manipulate in some form or another? This quick example from Honeybadger shows how they use temporary tables to make the process a bit smoother. Honeybadger.​io [Membership In a Box with PG-Auth](http://rob.conery.io/2015/03/17/membership-in-a-box-with-pg-auth/?utm_source=postgresweekly&utm_medium=email)A few weeks back Rob had a post about how to do auth well with Postgres, but now he’s followed it up with an actual working example in Node. Rob Conery#code [capistrano-db_sync: Fast and Sophisticated Remote Postgres Import in Ruby](https://github.com/rafaelsales/capistrano-db_sync?utm_source=postgresweekly&utm_medium=email)A great Capistrano tool for fast and sophisticated remote database import using the best of Postgres 9.2.x Rafael Sales#code [SQL School](http://sqlschool.modeanalytics.com/the-basics/introduction.html?utm_source=postgresweekly&utm_medium=email)Are you or someone you know looking to find a good resource for learning SQL? Here’s a great walkthrough of the basics. Mode Analytics [Job: Systemadministrator / Platform Engineer DevOps (m/w) eShop – Cassandra, Puppet, Jenkins, Linux](http://kaufhof-jobs.dvinci.de/cgi-bin/appl/selfservice.pl?action=jobdetail;job_pub_nr=71834101-3E82-4552-821A-438F85F8F35B;p=homepage;preview=1)DevOps-Kollegen mit Gespür für modernste Technologien und Spaß an der Optimierung von Workflows und Prozessen für unser zentrales Ops-Team in einem Kanban-getriebenen Umfeld gesucht! Bewerbung gerne an gundula.pabst@kaufhof.de Galeria Kaufhof#sponsored#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/97) [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