An intro to JSON data types in PostgreSQL

The latest Postgres news, articles, tools, and projects.

#264 — July 11, 2018 Read on the Web Postgres Weekly ▶  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 pgBadger — pgBadger 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

Curated by Cooperpress and Craig Kerstiens Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom