Postgres Weekly

#254 — May 2, 2018

Read on the Web

Postgres Weekly

Inserting JSON with SQL

Postgres Data Types: JSON (and XML) — The latest in a fantastic series digging into Postgres’ support for various types of data. This week it’s JSON, and XML has been covered too.

Dimitri Fontaine

A Quick Look at How Postgres 11's CREATE PROCEDURE Feature Will Work — CREATE PROCEDURE will give us the power to to run transactions in procedural code. A brief example here.

Hans-Jürgen Schönig

Postgres Vision Keynote Speakers Announced — Jeff Sutherland, inventor of the SCRUM, Lauren Nelson, principal analyst, Forrester, and Dan Lyons, author of: Options: The Secret Life of Steve Jobs and Disrupted: My Misadventure in the Start-Up Bubble.

Postgres Vision 2018 sponsor

Comparing Cloud Database Options for PostgreSQL — A high level comparison of Amazon RDS, Google Cloud SQL, Azure’s Postgres offering, Heroku, EnterpriseDB, Citus DB Cloud, and ElephantSQL.

Severalnines

PipelineDB 0.9.9: One More Release Until PipelineDB is a Postgres Extension — PipelineDB is a fork of Postgres that turns it into a streaming time series database, but it’s quickly on its way to becoming an extension instead.

Derek Nelson

pg_wal Is Too Big.. What's Going On? — The tale behind working out why a Postgres server failed due to running out of disk space and how to mitigate the problem in future.

Alexey Lesovsky

Using SQL to Query Postgres and Other Databases with Presto — Presto is a distributed SQL query engine by Facebook that can connect to other data sources, as demonstrated here.

Mark Litwintschik

Announcing the Release of AgensGraph 1.3 — AgensGraph is a multi-model graph database based on Postgres.

Bitnine Global

Coming to PostgreSQL 11: Partition Pruning At Execution Time

Hubert depesz Lubaczewski

Unified Management & Automation for PostgreSQL

Severalnines sponsor

ora_migrator: Moving From Oracle to Postgres Even Faster — Want to migrate an Oracle database to Postgres with a single SQL query?

Hans-Jürgen Schönig

Issue 253 #254 Issue 255