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

Postgres Weekly Issue 53 - April 10, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/53)**Postgres Weekly****Issue 53**
April 10, 2014As always, thanks to [Craig Kerstiens](https://twitter.com/craigkerstiens) for continuing to curate Postgres Weekly :-)[PostgreSQL and the OpenSSL Heartbleed vulnerability](http://blog.hagander.net/archives/219-PostgreSQL-and-the-OpenSSL-Heartbleed-vulnerability.html?utm_source=postgresweekly&utm_medium=email)Hopefully by now you’ve read about the [Heartbleed vulnerability](http://heartbleed.com/) in OpenSSL. What you may not have checked is if your Postgres database is vulnerable - here’s how to do that._Magnus Hagander_["Postgres For Developers" - Notes From PGConf NYC 2014](http://www.garysieling.com/blog/postgres-developers-notes-pgconf-nyc-2014?utm_source=postgresweekly&utm_medium=email)From a talk at PGConf NYC by a core developer comes a look at a ton of helpful key features for being more powerful as a developer with your Postgres database._Gary Sieling_[DataFiller 2.0.0: Data Generation from a Postgres Schema](http://blog.coelho.net/database/2014/03/23/datafiller-2-0-0/?utm_source=postgresweekly&utm_medium=email)DataFiller processes a PostgreSQL database schema file augmented with directives in comments, and generates random data matching this schema, taking into account constraints such as types, but also primary key, unique, foreign keys, not null…_Fabien Coelho_[Job: Postgres Database Administrator (San Antonio, TX)](https://uscareers-rackspace.icims.com/jobs/9338/postgres-database-administrator/job?cm_mmc=ContentMKTG-_-DBWeekly-_-MDB-_-Postgresjob?utm_source=postgresweekly&utm_medium=email)Responsibilities include database upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning. In addition, DBA’s will provide support and direction to developers and other support personnel as needed._RackspaceSponsored_[Postgres 9.4 Feature Highlight: Indexing JSON Data with the jsonb Data Type](http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-indexing-jsonb/?utm_source=postgresweekly&utm_medium=email)We recently highlighted a lot about the new jsonb datatype. Curious what it actually means for indexing and performance of your database? Well here’s a first look._Michael Paquier_[The History of PostgreSQL + PGConf NYC](https://www.youtube.com/watch?v=2RSkI9dxdbo?utm_source=postgresweekly&utm_medium=email)From the recent PGConf NYC that just wrapped up here’s a beautifully done video that takes you through a bit of the history behind PostgreSQL. Perhaps you’ll even learn a few things about the project in this that you didn’t know before._YouTube_[JSONB: "Wildcard" Query](http://obartunov.livejournal.com/177977.html?utm_source=postgresweekly&utm_medium=email)One more look at the performance of jsonb. While this one is a bit shorter than our other this week, it came from one of the contributors of jsonb, and shows a clear win in Postgres getting the datatype.[mongo-sql (for Node)](https://github.com/goodybag/mongo-sql?utm_source=postgresweekly&utm_medium=email)An extensible SQL generation library for JavaScript with a focus on introspectibility._Goodybag_[PostgreSQL Columnar Store for Analytic Workloads](http://citusdata.com/blog/76-postgresql-columnar-store-for-analytics?utm_source=postgresweekly&utm_medium=email)[Citus Data](http://www.citusdata.com) just released an open source columnar store for Postgres. The columnar store boasts some huge performance gains in certain cases and operates as an FDW._Citus Data_[Postgresql Range Basics](http://www.davidhampgonsalves.com/Postgres-ranges?utm_source=postgresweekly&utm_medium=email)Range types are one of the many datatypes in Postgres, and while not most commonly used when you do need them they’re extremely handy. Here’s a short guide on the basics of working with them._David Hamp-Gonsalves_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|*)