---
title: "An intro to JSON data types in PostgreSQL"
publication: "Postgres Weekly"
issue: 264
published_at: "2018-07-11"
canonical_url: "https://postgresweekly.com/issues/264"
---

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

#264 — July 11, 2018 

[Read on the Web](https://postgresweekly.com/issues/264)   

Postgres Weekly 

[![An Introduction to JSON Data Types in PostgreSQL\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ioowkslxgsnb99oehjjw.jpg)](https://blog.2ndquadrant.com/video-introduction-json-data-types-postgresql/)  

▶[An Introduction to JSON Data Types in PostgreSQL](https://blog.2ndquadrant.com/video-introduction-json-data-types-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](http://www.pateldenish.com/2018/07/audit-logging-using-jsonb-in-postgres.html) — 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.](http://www.pateldenish.com/2018/07/audit-logging-with-postgres-partitioning.html) 

Denish Patel   [![\](https://copm.s3.amazonaws.com/ed8829ee.png)](https://www.2ndquadrant.com/en/resources/bdr/?utm_source=cp&utm_medium=pgweekly&utm_campaign=bdrcppgweekly) 

[AlwaysOn Multi-master Replication for Distributed PostgreSQL](https://www.2ndquadrant.com/en/resources/bdr/?utm_source=cp&utm_medium=pgweekly&utm_campaign=bdrcppgweekly) — 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](https://tapoueh.org/blog/2018/07/modeling-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](https://www.cybertec-postgresql.com/en/a-beginners-guide-to-postgresqls-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](https://severalnines.com/blog/integrating-tools-manage-postgresql-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](http://www.postgresonline.com/journal/index.php?/archives/390-Using-procedures-for-batch-geocoding-and-other-batch-processing.html) — ANSI SQL’s `CREATE PROCEDURE` is coming to Postgres 11. 

Leo Hsu and Regina Obe   

[Postgres Log Analysis with pgBadger](https://severalnines.com/blog/postgresql-log-analysis-pgbadger) — [pgBadger](http://dalibo.github.io/pgbadger/) is a open source PostgreSQL log analyzer that generates HTML reports. 

Brian Fehrle   

[Streaming ETL in Practice with PostgreSQL, Apache Kafka, and KSQL](https://speakerdeck.com/rmoff/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](https://www.enterprisedb.com/blog/ready-test-your-postgres-skills) 

EnterpriseDB sponsor   

[Ask HN: Have You Ever Chosen Postgres Over Mongo and Regretted It?](https://news.ycombinator.com/item?id=17497164) — 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](https://www.postgresql.org/about/news/1868/) — 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](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom