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

Postgres Weekly 120   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 120 — August 26, 2015     

[Designing a PostgreSQL Document API](http://rob.conery.io/2015/08/20/designing-a-postgresql-document-api/?utm_source=postgresweekly&utm_medium=email)Here’s part one of the series of using Postgres as a document store. In short, it works, but could use a bit of usability tuning. Fortunately much of this is coming but it’s still quite workable today - take a look at how. Rob Conery [Generating MoM, YoY and CMGR from SQL](http://tech.yunojuno.com/sql-window-functions?utm_source=postgresweekly&utm_medium=email)Window functions are extremely powerful and you can do many things with them. One very common capability is computing month over month growth without having to break out a scripting language or Excel. YunoJuno Tech Team [Spotify PostgreSQL Metrics: Tool That Extracts and Provides Metrics On Your Database](https://github.com/spotify/postgresql-metrics?utm_source=postgresweekly&utm_medium=email)A CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. Spotify#tools [Learn Postgres Admin from Community Leader Bruce Momjian](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tcombobm9)Bruce Momjian teaches the popular course Comprehensive PostgreSQL Administration again in September, covering foundational and advanced topics needed for success. Join Bruce and learn from his tips in this live on-line session. 20% off promo code COMB-WEB-01. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/b7413ff2.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tcombobm9) [pgfutter: Import CSV and JSON Into PostgreSQL The Easy Way](https://github.com/lukasmartinelli/pgfutter?utm_source=postgresweekly&utm_medium=email)Here’s an incredibly handy tool for importing CSV and JSON data directly into PostgreSQL. Lukas Martinelli#code [sql_firewall: SQL Firewall Extension for PostgreSQL](https://github.com/uptimejp/sql_firewall?utm_source=postgresweekly&utm_medium=email)Should a SQL injection vulnerability occur in your application it could be a huge disaster, here’s a newer approach for helping prevent such by analyzing every query and alerting on unknown queries against your system. Uptime Technologies#code [Row Level Security in PostgreSQL 9.5](http://jimkeener.com/posts/postgres-9.5-row-level-security-rls?utm_source=postgresweekly&utm_medium=email)Row Level Security (RLS) allows the contents of a table to be filtered before being returned to the user. James Keener [PostgreSQL Document API Part 3: Finding Things](http://rob.conery.io/2015/08/25/postgresql-document-api-part-3-finding-things/?utm_source=postgresweekly&utm_medium=email)A look at searching documents stored in Postgres. It can be extremely performant thanks to JSONB and a combination of indexing and full text search. Rob Conery [Meteor PostgreSQL](http://meteor-postgres.readthedocs.org/en/latest/?utm_source=postgresweekly&utm_medium=email)Meteor now has a preview version of Postgres support available. readthedocs.​org [What's New in PgBouncer 1.6](http://blog.2ndquadrant.com/pgbouncer-1-6/?utm_source=postgresweekly&utm_medium=email)PgBouncer is still the best solution for connection pooling with Postgres in your application. With the newest release from just a few weeks ago there’s a number of improvements that make it even more usable. 2ndQuadrant    

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