#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 WorkCREATE 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 PrestoPresto 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