PostgreSQL's secret NoSQL superpowers
summary
Uses PostgreSQL 9.5 and shows exact commands: xmlparse + XPath to extract titles from a book catalog but XML cannot be updated natively; creates the hstore extension, stores key/value blobs, adds indexes on keys and uses containment and concatenation to update or delete rows; compares text JSON to jsonb (binary, faster reads, supports indexes); demonstrates the jsonb_set function to update nested fields, jsonb_pretty caching quirks, and warns that heavy writes to large JSON fields cause row lock contention.
AI-written summary · about
chapters (20)
- 0:00Intro
- 1:40Questions to ask yourself
- 3:48No sequel super powers
- 4:50XML
- 5:43Creating your schema
- 5:58Inserting data
- 7:03One row at a time
- 13:22Limitations
- 14:19ReadWrite
- 15:32Sample Data
- 16:09Explicit Typecast
- 18:22Hstore
- 23:18Updating Hstore
- 28:14Deleting Hstore
- 33:05Operators
- 34:53Text JSON
- 36:12JSON Object Keys
- 44:09Updating JSON Object Keys
- 49:49Recap
- 50:53Questions
