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

Postgres Weekly Issue 87 - January 7, 2015

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/87)**Postgres Weekly****Issue 87**
January 7, 2015[pgcli - An Enhanced Postgres CLI](http://pgcli.com/?utm_source=postgresweekly&utm_medium=email)Want psql on steroids? Here it is. While it’s a Python package, it should still be easy to get setup even if you’re not a Python developer. It features auto-completion, syntax highlighting, and more._Amjith Ramanujam_[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_[An Update on Parallelism in Postgres](http://rhaas.blogspot.com/2014/12/parallelism-update.html?utm_source=postgresweekly&utm_medium=email)_Robert Haas_[A New Way to Measure Business Impact](https://portal.appdynamics.com/account/signup/signupForm/?utm_source=cooperpress=sponsorship=postgres%20weekly=a%20new%20way%20to%20measure%20business%20impact=1_7_2015?utm_source=postgresweekly&utm_medium=email)As application complexity increases, it’s important to keep a focus on what really matters to your business - your application revenue. With AppDynamics, you get 100% visibility into application revenue in real time so you can now be more effective in how you identify, isolate, and resolve application issues that affect the business. [Get started with AppDynamics.](https://portal.appdynamics.com/account/signup/signupForm/?utm_source=cooperpress&utm_medium=sponsorship&utm_campaign=postgres%20weekly&utm_content=a%20new%20way%20to%20measure%20business%20impact&utm_term=1_7_2015)_AppDynamicsSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/31377/t.png)](https://portal.appdynamics.com/account/signup/signupForm/?utm_source=cooperpress=sponsorship=postgres%20weekly=a%20new%20way%20to%20measure%20business%20impact=1_7_2015?utm_source=postgresweekly&utm_medium=email)[Building a College Basketball Database — Part 1: Scraping ESPN](http://patrick-howell.com/2015/01/05/building-a-college-basketball-database-part-1-scraping-espn/?utm_source=postgresweekly&utm_medium=email)Want an excuse to scrape some data and work on a fun side project with Postgres? Here’s the first of a few posts that show scraping college basketball data and storing it within your favorite relational DB._Patrick Howell_[PostgreSQL: Documentation: 9.4: JSON Types](http://www.postgresql.org/docs/9.4/static/datatype-json.html?utm_source=postgresweekly&utm_medium=email)9.4 was released just before the holidays with one of the biggest features being the new JSONB datatype. If you haven’t already explored JSONB, take a look at the docs and see what's newly available._Postgresql.org_[SQL Is Your Friend, Part 1](http://cookingco.de/2014/12/17/sql-is-your-friend-part-1/?utm_source=postgresweekly&utm_medium=email)Want a list of reasons to fall in love with Postgres all over again? Here’s the first of a great multi-part series highlighting the JSON datatype and the flexibility it brings._Barrett Clark_[SQL Is Your Friend, Part 2](http://cookingco.de/2014/12/18/sql-is-your-friend-part-2/?utm_source=postgresweekly&utm_medium=email)In part two of the series this post looks at something that will make you appear like an absolute badass to most others if you’re able to master it - window functions. The applications are rare but powerful, such as month over month growth, ranking within sub-groups, and more._Barrett Clark_[Announcing que-go: a Go port of the Ruby Que job queue for Postgres](https://bgentry.io/blog/2014/12/31/announcing-que-go?utm_source=postgresweekly&utm_medium=email)Want to have a queue that just works for your particular language with Postgres without trying to work with any and all backends? Here’s your answer with a port of the Ruby Que job queue for GoLang._Blake Gentry_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)