#264 — July 11, 2018

Read on the Web

Postgres Weekly

An Introduction to JSON Data Types in PostgreSQL

▶  An Introduction to JSON Data Types in PostgreSQL — We don’t often get a high quality videos in this newsletter and this isn’t as basic as the title suggests. A good one-stop-shop to get up to speed with working with JSON in Postgres.

Andrew Dunstan

Audit Logging using JSONB in Postgres — A look at a way to use the JSONB data type to store auditing details using a trigger-based approach. In a followup post, Denish also looks at audit logging using Postgres partitioning.

Denish Patel

AlwaysOn Multi-master Replication for Distributed PostgreSQL — Postgres-BDR from 2ndQuadrant presents true high availability with Point-In-Time Recovery. BDR provides rolling upgrades, with zero downtime, for geographically distributed PostgreSQL databases.

2ndQuadrant PostgreSQL Products sponsor

Modelling for Concurrency — A practical exercise oriented around modelling a tweet-like data model to tolerate concurrent updates relating to the same ‘tweet’, though “if you know that your application has to scale, think about how to avoid concurrent activity that competes against a single shared resource.”

Dimitri Fontaine

A Beginner’s Guide to UPDATE and Autovacuum“In 90% of all cases autovacuum does a perfect job and cleans out tables just the way it should be. However, there are cases, in which things can turn out to be a problem..”

Hans-Jürgen Schönig

Integrating Tools to Manage Postgres in Production — What types of tools do you need to effectively run a Postgres instance in a production environment?

Achilleas Mantzios

Using PG11 Procedures for Batch Geocoding and Other Batch Processing — ANSI SQL’s CREATE PROCEDURE is coming to Postgres 11.

Leo Hsu and Regina Obe

Postgres Log Analysis with pgBadgerpgBadger is a open source PostgreSQL log analyzer that generates HTML reports.

Brian Fehrle

Streaming ETL in Practice with PostgreSQL, Apache Kafka, and KSQL — Have you thought you needed to be a programmer to do stream processing and build streaming data pipelines? Think again!

Robin Moffatt

Test Your PostgreSQL Skills with PostgreSQL 10 Associate Certification

EnterpriseDB sponsor

Ask HN: Have You Ever Chosen Postgres Over Mongo and Regretted It? — Most of the comments suggest no, though Mongo’s schemaless nature can initially make prototypes faster to develop.

Hacker News

E-Maj 2.3.0: Tracks Updates on Tables Sets with Rollback Capabilities — An extension that enables fine-grained write logging and time travel on database subsets. This new version supports Postgres 9.2 up to v11.

Philippe Beaudoin