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

Postgres Weekly 102   . 

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

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

[Managing Big Enough Data in Postgres](http://blog.tarkalabs.com/2015/04/16/managing-big-enough-data-in-postgres/?utm_source=postgresweekly&utm_medium=email)Postgres is an amazing database when your active data fits in memory. If it doesn’t then you’re starting to look at a sizable dataset (greater than 100 GB) and at that point a little more care and effort may be required.. Tarka Labs [PostgreSQL Dockerfile](https://registry.hub.docker.com/u/bettervoice/postgresql-container/?utm_source=postgresweekly&utm_medium=email)This project can be used to deploy a PostgreSQL server inside a Docker container. Docker Hub Registry [Tuning for Performance in Production – The DBA Role](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=cooperpress&utm_medium=nl&utm_campaign=tperf)Over time, conditions change including data growth, usage patterns, and the amount of resources available to the database. Periodic tuning is the Postgres DBAs role to ensure that things continue to run smoothly. Learn how to [optimize performance](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=cooperpress=nl=bperf) or get help with a [database check up](http://www.enterprisedb.com/ahc?utm_source=cooperpress=nl=bahc). EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/475a447d.jpg)](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=cooperpress&utm_medium=nl&utm_campaign=tperf) [How to Handle Key-Value Data in Postgres](http://stormatics.com/howto-handle-key-value-data-in-postgresql-the-hstore-contrib/?utm_source=postgresweekly&utm_medium=email)Sure, Postgres is a relational database but that doesn’t mean it doesn’t have the flexibility to work with key-value data. HStore is an awesome solution for that and it’s a built-in extension. Stormatics [meteor-pg: Reactive PostgreSQL for Meteor](https://github.com/numtel/meteor-pg?utm_source=postgresweekly&utm_medium=email)Working with Meteor because it’s a more responsive framework? Well Postgres can play well with it too using this latest package that brings reactive Postgres to Meteor. Ben Green#code [DDL.js — Get JSON Schema Describing Your PostgreSQL Tables](https://github.com/moll/js-ddl?utm_source=postgresweekly&utm_medium=email)Want an JSON Schema representation of your database with little to no effort? Here’s a simple and easy way to expose your Postgres DB schema directly in JSON Schema. Andri Möll#code [Storing URIs in PostgreSQL](http://peter.eisentraut.org/blog/2015/04/16/storing-uris-in-postgresql/?utm_source=postgresweekly&utm_medium=email)First covered just a few months ago in PG Weekly, there’s a nice update which is better production-ized for handling URIs in Postgres with a ready to use extension. Peter Eisentraut [Mongolike: A Proof of Concept MongoDB Clone Built On Postgres](https://github.com/JerrySievert/mongolike?utm_source=postgresweekly&utm_medium=email) Jerry Sievert#code [Massive 2.0: A Postgres-Centric Data Access Tool for Node.js](https://github.com/robconery/massive-js?utm_source=postgresweekly&utm_medium=email) Rob Conery#code [Senior PostgreSQL Expert](https://www.adjust.com/careers/#senior-postgresql-expert)You love to hack Postgres? And C is more than the third letter of the alphabet for you? Join us as the PostgreSQL expert to help us administrate databases for real-time analytics over terabytes of mobile app data. adjust#job    

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