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

Postgres Weekly 127   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 127 — October 14, 2015     

[The PostgreSQL 2015-10-08 Security Update Release](http://www.postgresql.org/about/news/1615/?utm_source=postgresweekly&utm_medium=email)A new security update from Postgres, this time addressing a DoS vulnerability based around JSON and JSONB values. Available for 9.4.5, 9.3.10, 9.2.14, 9.1.19 and 9.023, you should upgrade now, and especially if using JSON/JSONB. Postgresql.​org#news [UUID vs BIGSERIAL for Primary Keys](http://thebuild.com/blog/2015/10/08/uuid-vs-bigserial-for-primary-keys/?utm_source=postgresweekly&utm_medium=email)Not the most exciting topic, but the IDs on your tables have a critical role to play and it's important to get it right. Just ask Instagram or other applications that run out of index IDs because they’re using integers. Fortunately it’s easily solved. The Build [Scale Out Postgres for Real-Time Big Data Using CitusDB](http://info.citusdata.com/BigDataPW3.html?utm_source=postgresweekly&utm_medium=email)CitusDB delivers [real-time insights](http://info.citusdata.com/BigDataPW3.html) into your Big Data while reducing the cost and complexity of your database infrastructure and leverages your existing knowledge and applications. Supports structured or unstructured data and [horizontally scales.](http://info.citusdata.com/BigDataPW3.html) Citus Data#sponsored[![\](https://copm.s3.amazonaws.com/8aa06404.png)](http://info.citusdata.com/BigDataPW3.html?utm_source=postgresweekly&utm_medium=email) [What PostgreSQL Has Over Other Open Source SQL Databases](https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases/?utm_source=postgresweekly&utm_medium=email)First in a series of posts looking at Postgres’ strengths. First, the storage of data. Compose#opinion [PostgreSQL Hot Standby Feedback, How It Works](http://blog.postgresql-consulting.com/2015/09/postgresql-hot-standby-feedback-how-it.html?utm_source=postgresweekly&utm_medium=email)Replication and standbys with Postgres can have lots of implications for how your database works. One example is it will automatically cancel queries that run for a certain amount of time so that replication continues. Get the deeper run down of how it works and what it all means. Alexey Lesovsky [Waiting for 9.6 – Add CASCADE support for CREATE EXTENSION.](http://www.depesz.com/2015/10/08/waiting-for-9-6-add-cascade-support-for-create-extension/?utm_source=postgresweekly&utm_medium=email)Postgres is continuing to improve its usability and smooth out rough edges. One of the latest commits for 9.6 will allow dependencies on different extensions to be able to cascade rather than simply error if you now specify a flag. Hubert depesz Lubaczewski [Database Designer for PostgreSQL 1.10.6 Available](http://www.postgresql.org/about/news/1619/?utm_source=postgresweekly&utm_medium=email)Introduces enhanced support for Windows 10 and optional anonymous statistics. MicroOLAP#news [Manage Your PostgreSQL Extensions with pgbundle](http://big-elephants.com/2015-10/pgbundle-manage-your-postgres-extension-dependencies/?utm_source=postgresweekly&utm_medium=email)A Bundler-inspired Ruby-based tool for managing those all powerful Postgres extensions. adjust GmbH#tools#code [SQL for Beginners: Installing PostgreSQL and Creating Your First Database](https://www.youtube.com/watch?v=xaWlS9HtWYwa&utm_source=postgresweekly&utm_medium=email)Here’s a great new database series, which highlights SQL but specifically Postgres as well. Start with setting up your Postgres instance and then advance on to other parts in the series such as how to [start inserting data](https://www.youtube.com/watch?v=fA0jpjwi4J8a) YouTube#video [psql-api: A Rapid RESTful API for Postgres](https://github.com/QBisConsult/psql-api?utm_source=postgresweekly&utm_medium=email)Built on Node, runs on Linux or Windows. QBisConsult#code [New Version of Oracle to Postgres Converter Released](http://www.convert-in.com/ora2pgs.htm?utm_source=postgresweekly&utm_medium=email) Intelligent Converters#news#tools [Join The Top 3% of Freelance PostgreSQL Developers Worldwide](http://www.toptal.com/developers?utm_source=cooperpress&utm_medium=newsletter&utm_content=postgres_weekly&utm_campaign=top_3)Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers. Toptal#sponsored    

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