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

Postgres Weekly 101   . 

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

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

[Functions and Addressing JSON Data](http://bonesmoses.org/2015/04/10/pg-phriday-functions-and-addressing-json-data/?utm_source=postgresweekly&utm_medium=email)Postgres is great at storing and retrieving data, including JSON these days. But what if you need to find a specific value in JSON then manipulate it? That takes a little more effort, but as highlighted here can be easily done with a little PLV8. Shaun M.​ Thomas [PG Bouncer: Lightweight Connection Pooler for PostgreSQL](https://pgbouncer.github.io/?utm_source=postgresweekly&utm_medium=email)PG Bouncer, the best connection pooling application for Postgres, has a new home along with a release that contains some great updates. A good excuse to update your version or check it out if you’ve not yet. pgbouncer.​github.​io [Browser-based query tool and PostgreSQL client](https://www.jackdb.com/)Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free. JackDB#sponsored[![\](https://copm.s3.amazonaws.com/1396702f.png)](https://www.jackdb.com/) [Postgres 9.5 Feature Highlight: log_autovacuum_min_duration At Relation Level](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-log-autovacuum-min-duration-relation/?utm_source=postgresweekly&utm_medium=email) Michael Paquier [Connecting A Pakyow App to Postgres with Sequel](http://notmagic.org/2015/04/10/pakyow-sequel?utm_source=postgresweekly&utm_medium=email)Pakyow, a framework in Ruby that’s focused on view-first development, plays well with many databases, but most importantly Postgres. Here’s a look at plugging in Postgres via Sequel (one of the best Ruby ORMs). Bryan Powell [Dynamically disabling triggers without locks](http://adpgtech.blogspot.com/2015/04/dynamically-disabling-triggers-without.html?utm_source=postgresweekly&utm_medium=email)A big part of the performance improvements over time come from reducing when and how long locks are held for on certain operations. Take a look at this recently landed feature to no longer hold locks when running an alter table for triggers. Andrew Dunstan [How To Create Reports in Tableau with PostgreSQL](http://stormatics.com/howto-create-reports-in-tableau-with-postgresql-database/?utm_source=postgresweekly&utm_medium=email)Tableau is a popular suite of data visualization and reporting tools used in the business intelligence sector. Stormatics    

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