JSON data structure – the hidden gem inside your database engine
summary
Demonstrates using JSONB columns in PostgreSQL to mix relational rows with flexible document fields, shows live SQL operators to extract keys, filter arrays, and index JSON paths with GIN indexing, and cites a 50 million records benchmark where Postgres wins ingestion, selection and storage over MongoDB by large margins. Describes a Trello-style card schema, production use at Telenor Health scaling toward 20 million users with millions of daily records, and notes per-key updates remain cheaper in MongoDB.
AI-written summary · about
chapters (18)
- 0:00Introduction
- 0:39About the speaker
- 1:05Spaghetti analogy
- 1:44Database choice
- 2:34Spark example
- 3:00Jason
- 3:45Unstructured data
- 4:39Jason B
- 5:42Card structure
- 6:29Data structure
- 7:11Query data
- 7:58Filter data
- 8:11Check data
- 8:26Nested JSON objects
- 8:44Indexing
- 9:18Operators
- 10:02Postgres vs MongoDB
- 11:05Automatic sharding
related talks
25mJSON in PostgreSQL - evil data type or just needs to be tamed?
49mShould I use JSON in PostgreSQL?
35mLeveraging PostgreSQL 17's JSONB for Enhanced Data Modeling
48mPostgres and Json - How to get the best of them?
42mNoSQL as Not Only SQL
05mPostgreSQL JSON JSONB Making the Right Choice for Your Application
51mDealing with JSON in the relational world
53mThe NoSQL Store everyone ignores: PostgreSQL