Using JSON with Postgres 9 3
summary
PostgreSQL 9.3 adds concrete JSON generators, extractors and an extendable parsing API so code actually produces and queries JSON instead of treating blobs as text. Expect to_json/array_to_json for generation, operators like -> and ->> and functions json_populate_record( set ), json_each, json_array_elements for extraction, plus hooks to write custom handlers. The extension-built json_build_object/array assembles arbitrary trees. Limits matter: a single JSON datum tops out near 1GB and parsing-every-time can hurt performance.
AI-written summary · about
chapters (31)
- 0:00Introduction
- 1:45What is JSON
- 3:07JSON Structure
- 4:52Why JSON
- 5:21Why not JSON
- 6:17JSON in Postgres
- 8:13Whats missing
- 9:35To JSON
- 10:40Cast to JSON
- 13:30Event handlers
- 15:54JSON vs Text
- 16:52Dash Error
- 17:56Text View
- 18:14Array
- 19:09Path constructs
- 19:51Part of a record
- 21:24Keyvalue pairs
- 21:43Arrays
- 22:17Level
- 23:41State object
- 24:43Events
- 25:19Scalar
- 25:47Code
- 26:48Transformation
- 28:27Generating JSON
- 30:02Building JSON
- 30:33Nested JSON
- 31:04JSON Tree
- 32:03Binary Representation
- 35:57Sponsors
- 36:26Data size
related talks
05mPostgreSQL JSON JSONB Making the Right Choice for Your Application
49mShould I use JSON in PostgreSQL?
42mNoSQL as Not Only SQL
48mPostgres and Json - How to get the best of them?
25mJSON in PostgreSQL - evil data type or just needs to be tamed?
48mThe road to new SQL/JSON features
35mLeveraging PostgreSQL 17's JSONB for Enhanced Data Modeling
23mEven JSONB In Postgres Needs Schemas