---
title: "This Week's PostgreSQL News (#59)"
publication: "Postgres Weekly"
issue: 59
published_at: "2014-05-28"
canonical_url: "https://postgresweekly.com/issues/59"
---

Postgres Weekly Issue 59 - May 28, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/59)**Postgres Weekly****Issue 59**
May 28, 2014[Postgres and Connection Pooling](http://www.craigkerstiens.com/2014/05/22/on-connection-pooling/?utm_source=postgresweekly&utm_medium=email)Heard about connection pooling, but unsure what it is, when/if you need it? Here’s a high level overview from myself nailing all of those points as well as some of the key options available to Postgres._Craig Kerstiens_[Querying Time Series in Postgresql](http://no0p.github.io/postgresql/2014/05/08/timeseries-tips-pg.html?utm_source=postgresweekly&utm_medium=email)Postgres has had robust support for dealing with times for some time. If you have time series in your database at all here’s a look at some parts of Postgres that can be helpful._no0p_[Scaling Gilt with PostgreSQL](http://tech.gilt.com/post/85923439469/scaling-gilt-with-postgresql-from-one-database-to-many?utm_source=postgresweekly&utm_medium=email)Here’s a great high level case study from Gilt on why they chose Postgres, what they’re doing with it, and the experience they’ve had with it. If you’re in need of use cases and case studies their a great one._Gilt_[SQLite and Postgres](http://www.pgcon.org/2014/schedule/attachments/319_PGCon2014OpeningKeynote.pdf?utm_source=postgresweekly&utm_medium=email)One of the biggest Postgres conferences (PGCon) just wrapped up last week. In case you weren’t there we’ll be having a variety of content flow out of it over the coming weeks, and to kick it off here’s the slides from the keynote on not just Postgres but largely SQLite._PGCon_[Avoid Rails When Generating JSON responses with PostgreSQL](http://reefpoints.dockyard.com/2014/05/27/avoid-rails-when-generating-json-responses-with-postgresql.html?utm_source=postgresweekly&utm_medium=email)Building an API that returns JSON? If you’re tempted to do some queries, build up JSON in a higher level language and return it, maybe you should think twice. Here’s an awesome post that shows how CTEs can be great for delivering complex result sets and also much more performant._Dan McClain_[rdb - ORM for Node](https://www.npmjs.org/package/rdb?utm_source=postgresweekly&utm_medium=email)Use Node and Postgres and still looking for a better developer experience? Here’s yet another ORM for node which hopes to make Postgres as much better experience for Node devs._npmjs.org_[9.4 JSON Slides](http://www.slideshare.net/amdunstan/94json?utm_source=postgresweekly&utm_medium=email)If you’ve followed along JSON has been a very common topic for Postgres for several releases. If you need to know what’s new for JSON in 9.4, or even just want a clear picture of where it’s come from here’s a great set of slides from PG Con covering much of the past, present and future for JSON in Postgres._Andrew Dunstan_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|*)