NoSQL as Not Only SQL
summary
A hands‑on tour of PostgreSQL JSON features that names real tools and numbers: JSONB (compressed, transactional) on 9.4+, jsonb_set and concatenation operators for updates, the minus operator for deletes, jsonb_to_recordset and row_to_json for conversion, and GIN index to speed queries. Importing ~600,000 Amazon reviews via COPY takes ~7s, building the GIN index ~20s, and a typical aggregate drops from ~250ms to ~8ms. 9.5 adds upsert and 9.6 adds jsonb_insert.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 5:01Jason functions
- 6:12Jason operators
- 6:50Jason indexes
- 8:19Jason function
- 9:04JSB functions
- 10:44Tables
- 11:22CTE
- 26:29Manipulation
- 30:29Concatenation operator
- 33:09Importing data
- 34:39Calculating data
- 35:59Speed
related talks
35mLeveraging PostgreSQL 17's JSONB for Enhanced Data Modeling
48mThe NoSQL Way in PostgreSQL
53mNoSQL Best Practices for PostgreSQL
05mPostgreSQL JSON JSONB Making the Right Choice for Your Application
48mPostgres and Json - How to get the best of them?
49mShould I use JSON in PostgreSQL?
59mPostgreSQL's secret NoSQL superpowers
28mPostgreSQL 9.4 and Beyond