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

Postgres Weekly 115   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 115 — July 22, 2015     

[ZomboDB: Postgres Extension For Elasticsearch-Backed Indexes](https://github.com/zombodb/zombodb?utm_source=postgresweekly&utm_medium=email)An extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch. In order to achieve this, ZomboDB implements Postgres’ Access Method API. ZomboDB#code [pgBadger: A PostgreSQL Log Analyzer](http://dalibo.github.io/pgbadger/?utm_source=postgresweekly&utm_medium=email)A PostgreSQL log analyzer built for speed with fully detailed reports from your PostgreSQL log file. It’s a single small Perl script. Dalibo#code [Optimize Postgres Performance with Summer Training Classes](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafZAAQ?utm_source=cooperpress&utm_medium=nl&utm_campaign=T115)[Tuning and Maintenance](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafZAAQ?utm_source=cooperpress=nl=b115) (1 day) teaches practical ways to optimize the performance of a PostgreSQL server. With [Foundations of Postgres Administration](http://www.enterprisedb.com/store/products/dba-training/01t500000031mz3AAA?utm_source=cooperpress=nl=b115) (3 days) you learn the essential details for successful Postgres administration. Both are offered on-line with a live instructor, or in an [on-demand format](http://www.enterprisedb.com/store/products/dba-training?utm_source=cooperpress=nl=b115). EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/b125d4fe.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafZAAQ?utm_source=cooperpress&utm_medium=nl&utm_campaign=T115) [Selectively Firing Postgres Triggers](http://blog.endpoint.com/2015/07/selectively-firing-postgres-triggers.html?utm_source=postgresweekly&utm_medium=email)Triggers can be useful to fire off updates or cascading changes at times, but there’s cases where you may want to explicitly opt out of them running. Here’s your guide on how, and more on when this may be useful. Greg Sabino Mullane [Migrating to JSON in PostgreSQL](https://developer.s24.com/blog/migrating-json-postgresql.html?utm_source=postgresweekly&utm_medium=email)If you’ve had your data for some time in Postgres it’s probably nicely normalized in tables, but what if you want to get it into the new JSON datatype for flexibility? Here’s you’re guide on going from columns to JSON. Jörg Rathlev [Waiting for 9.6: Add psql \ev and \sv Commands for Editing and Showing View Definitions](http://www.depesz.com/2015/07/21/waiting-for-9-6-add-psql-ev-and-sv-commands-for-editing-and-showing-view-definitions/?utm_source=postgresweekly&utm_medium=email)OK, Postgres 9.5 hasn’t landed yet, but patches ready for 9.6 are already landing. While it’s a relatively minor usability improvement, for viewing details around views and editing them, this should prove handy. Hubert depesz Lubaczewski [PostgREST: A REST API for Any Postgres Database](https://github.com/begriffs/postgrest?utm_source=postgresweekly&utm_medium=email)Want an out of the box REST API on top of your Postgres database? Here’s the tool for it. You can take a test drive with [this demo](https://postgrest.herokuapp.com/) Joe Nelson#code [A New Commercial ODBC Driver for PostgreSQL](http://www.postgresql.org/about/news/1598/?utm_source=postgresweekly&utm_medium=email)A feature-rich (and commercial/paid for) connectivity solution for ODBC-based applications to access PostgreSQL. Devart [Full Stack Engineer at Namely (New York, NY)](https://namely.workable.com/jobs/42718?utm_source=postgresweekly&utm_medium=email)Namely is an agile startup dedicated to building an end-to-end HR platform for businesses of all sizes. We’re looking for a skilled developer to contribute ideas, innovation, solutions and code to our product. Namely#job [Want to work on new projects? Make more money? Try a new stack?](https://hired.com/?utm_source=postgresweekly&utm_medium=email&utm_campaign=n-q3_15-petercooperpress&utm_content=options)On Hired, we'll bring the options to you. With over 2,000 pre-screened tech companies in 10 cities in the US UK, you'll be sure to find what you're looking for. Hired.​com#job    

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