---
title: "This Week's PostgreSQL Treats (#13)"
publication: "Postgres Weekly"
issue: 13
published_at: "2013-06-05"
canonical_url: "https://postgresweekly.com/issues/13"
---

Postgres Weekly Issue 13 - June 5, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/13)**Postgres Weekly****Issue 13**
June 5, 2013Featured[Postgres Open - Call for Presenters](http://postgresopen.org/2013/blog/2013/05/30/postgres-open-2013-call-presenters/?utm_source=postgresweekly&utm_medium=email)Postgres Open, the conference focused on Postgres users, has opened their CFP. They're looking for talks including case studies, how-tos, interesting Postgres innovations, and more. Submit your talk and save the date for the conference September.[![\](http://s3.amazonaws.com/nlga/uploads/item/image/11606/thumb125_pgopen_logo.png)](http://postgresopen.org/2013/blog/2013/05/30/postgres-open-2013-call-presenters/?utm_source=postgresweekly&utm_medium=email)[Postgres Indexing - A Collection of Indexing Tips](http://www.craigkerstiens.com/2013/05/30/a-collection-of-indexing-tips/?utm_source=postgresweekly&utm_medium=email)A collection of indexing tips including how to tell if indexes are unused, whether to use multiple individual indexes or composite indexes and more from me the editor, [@craigkerstiens](http://www.twitter.com/craigkerstiens).[PostgreSQL+](https://speakerdeck.com/gcoguiec/postgresql-plus?utm_source=postgresweekly&utm_medium=email)In case you've missed earlier talks around everything that comes in the box with Postgres, here's another great one covering datatypes, languages, indexes and more.From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

_Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to._[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)The rest[Postgres Indexes – Expression/Functional Indexing](http://www.craigkerstiens.com/2013/05/29/postgres-indexes-expression-or-functional-indexes/?utm_source=postgresweekly&utm_medium=email)In addition to the many types of indexes such as b-tree, gin, gist and others there's other powerful things you can do with them in postgres. Functional or expression based indexes allow you to manipulate data within your indexes to solve certain use cases especially well.[Managing PostgreSQL with Ansible](http://programming.oreilly.com/2013/05/beyond-puppet-and-chef-managing-postgresql-with-ansible.html?utm_source=postgresweekly&utm_medium=email)Looking to setup your configuration management and decide between Chef or Puppet? Well it may not be quite so simple, Ansible is one other option that can be simple to setup without the need for a central server. Enjoy this interview with Jay Edwards on why you should consider it and how to get started with it and PostgreSQL.[Mongress](https://github.com/umitanuki/mongres?utm_source=postgresweekly&utm_medium=email)From the person that enabled [JavaScript inside Postgres](https://code.google.com/p/plv8js/wiki/PLV8), [Hitoshi Harada](https://twitter.com/umitanuki) here's an attempt to replicate the functionality/API of mongo directly in Postgres. You can connect directly with the mongo client or with Postgres and now interact with your data anyway you like.[2011 Census Data in Postgres](http://govhack.minus34.com/absdata.html?utm_source=postgresweekly&utm_medium=email)Finding sample data sets can be a lot of work, at least if you want them easily imported to your DB from CSV. Here's a ready to load census data set formatted just for Postgres.[Run SQL on JSON files -- without any data loads](http://citusdata.com/blog/65-run-sql-on-json-files-without-any-data-loads?utm_source=postgresweekly&utm_medium=email)There's been a good bit of attention to what you can do with SQL and JSON particularly in Postgres recently. The guys at CitusDB have taken it one step further creating a JSON foreign data wrapper that can operate directly on JSON files without ever having to live in your DB.[PostgreSQL as NoSQL with Data Validation](http://blog.endpoint.com/2013/06/postgresql-as-nosql-with-data-validation.html?utm_source=postgresweekly&utm_medium=email)As it seems to be a hot topic in recent weeks here's yet another example of using Postgres as more of a non-relational store by taking advantage of JSON. This post in particular shows how you can still have good data validation, but also get good performance using the new JSON operators in 9.3Curated 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|*)