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.
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?
JsQuery - The jsonb query language with GIN indexing support (via SlideShare)
ToroDB: a NoSQL database built on top of PostgreSQL
PostgreSQL's Secret NoSQL Superpowers (via SlideShare)
SON in Postgres - The present and Future
PostgreSQL worst practices, version PGConf.US 2017 (via SlideShare)