Postgre(No)SQL - A JSON journey

This repository contains source material for a Torino Coding Society talk about PostgreSQL JSON data types.

SQL queries are performed against a dump of Open Library authors.

External resources

Replacing EAV with JSONB in PostgreSQL

Entity–attribute–value model - Wikipedia

Postgres JSON: Unleash the Power of Storing JSON in Postgres

What can you do with PostgreSQL and JSON?

NoSQL on ACID (PDF)

JsQuery - The jsonb query language with GIN indexing support (via SlideShare)

PostgreSQL and JSON: 2015

ToroDB: a NoSQL database built on top of PostgreSQL

JSON by example

SON Home Improvement

PostgreSQL's Secret NoSQL Superpowers (via SlideShare)

SON in Postgres - The present and Future

PostgreSQL worst practices, version PGConf.US 2017 (via SlideShare)

The NoSQL Store everyone ignores: PostgreSQL