Storing Non-Scalar Data
summary
Compares concrete storage and query behavior across Redis, MongoDB and PostgreSQL rather than restating topics: shows Redis sets/hashes and atomic ops (SADD, HINCRBY) for fast in‑memory tagging and counters; demonstrates MongoDB queries and the aggregation pipeline for nested documents and projections; explains Postgres JSONB with GIN indexes and HSTORE for OpenStreetMap‑style arbitrary tags, plus operators for updating/removing fields. Explicitly skips scalability and benchmarks.
AI-written summary · about
chapters (17)
- 0:00Intro
- 0:12Non-Scalar Data
- 3:00What Is This Presentation Not About
- 11:06Document Stores
- 17:03Documents: Complex
- 19:47Relational Databases
- 22:40PostgreSQL: HSTORE
- 29:51Redis: Query
- 34:44MongoDB: Aggregation
- 37:13PostgreSQL Query HSTORE
- 40:37PostgreSQL Query JSONB
- 45:11Redis: Indexes
- 47:12PostgreSQL: GIN Index
- 49:59Redis: Atomic Operations
- 51:35MongoDB: Update Operators
- 53:44Schema Validation
- 55:24Conclusions
related talks
53mThe NoSQL Store everyone ignores: PostgreSQL
45mDatabases for Data Science
35mAn Ode to 17 Databases in 39 minutes
29mPostgres Demystified
38mAn Ode to 17 Databases in 33 Minutes
14mJSON data structure – the hidden gem inside your database engine
33mSchemaless SQL The Best of Both Worlds
41mPostgreSQL is (probably) all you need