The NoSQL Store everyone ignores: PostgreSQL
summary
Postgres already stores schema‑free data and demonstrates it with concrete features and working examples: arrays (one‑based index, can generate null gaps when you write high indexes), hstore‑based audit diff using the - operator that records old/new key‑values via triggers, and JSONB with GIN index for fast containment queries and row_to_json microservices. The talk shows partitioning via child tables and a trigger that auto‑creates them, and cites real behavior (JSON vs JSONB storage cost, index use in EXPLAIN) that actually works.
AI-written summary · about
chapters (56)
- 0:00Intro
- 0:16Who is Stephan
- 1:04Who are you
- 3:07No sequel databases
- 3:52Classification
- 4:45Why Schemaless
- 6:51Why you should never use MongoDB
- 9:17PostgreSQL schemaless data types
- 11:21Create an array column
- 11:40Multidimensional arrays
- 13:19Selecting data
- 14:08Arrays
- 16:55Unnecessary rows
- 17:23Indexing
- 17:51Updating arrays
- 18:12Updating a single item
- 19:04Partial update
- 19:44Array functions
- 20:39Hstore
- 21:23Hstore on Linux
- 22:35Insert date
- 23:35Accessing elements
- 23:55Searching for a key
- 24:32Akey function
- 25:16Index function
- 25:36Update function
- 26:02minus function
- 26:31a keys function
- 26:52why is Hstore interesting
- 28:34JSON
- 29:41Metadata
- 29:51Inserting
- 30:08Array
- 30:38Query
- 32:03Unique indexes
- 32:36Updating JSON
- 32:57JSON functions
- 33:16Row to JSON
- 34:01Sub queries
- 34:39Data types
- 35:30JSONB
- 36:29Gene Index
- 37:17JSON Keys
- 37:53JSON vs JSON
- 40:32XML over FTP
- 41:21Wellformed XML
- 43:27Expert exists
- 44:01Query to XML
- 44:29XML functions
- 44:55Partitioning tables
- 45:28Child tables
- 46:41Create a table
- 47:31Foreign data wrappers
- 48:25PostgreSQL ecosystem
- 48:41Try it out
- 49:08Questions
