Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 127 — October 14, 2015
The PostgreSQL 2015-10-08 Security Update Release
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
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
CitusDB delivers real-time insights 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.
Citus Data    #sponsored 
What PostgreSQL Has Over Other Open Source SQL Databases
First in a series of posts looking at Postgres’ strengths. First, the storage of data.
Compose   #opinion 
PostgreSQL Hot Standby Feedback, How It Works
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.
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
Introduces enhanced support for Windows 10 and optional anonymous statistics.
MicroOLAP   #news 
Manage Your PostgreSQL Extensions with pgbundle
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
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
YouTube   #video 
psql-api: A Rapid RESTful API for Postgres
Built on Node, runs on Linux or Windows.
QBisConsult   #code 
New Version of Oracle to Postgres Converter Released
Intelligent Converters   #news #tools 
Join The Top 3% of Freelance PostgreSQL Developers Worldwide
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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.