How to explain PostgreSQL to kids
summary
Explains PostgreSQL as a magical toy box that stores toys into tables (toys and play_sessions), uses JSON for a “tiny scratch” field, and shows a sample SELECT with CTEs to find toys played before dinner and hidden-under-couch events. Describes MVCC for safe simultaneous play, a WAL “notebook” for crash recovery, and extensions like Citus and PostGIS plus pg_stat_statements for usage stats. Includes a Nanobanana-generated image and the exact prompt and shows the toy-box buttons Extend Search Insert Delete Vacuum.
AI-written summary · about
chapters (9)
- 0:00Introduction to talk
- 1:29Why explain PostgreSQL to kids
- 3:18Magical toy box analogy
- 6:53Why PostgreSQL is cool
- 10:43Custom toy types
- 12:28Multi-version concurrency
- 14:14PostgreSQL extensions
- 16:03Dedication and closing
- 18:15Q&A session
related talks
49mHow Databases Work - For Developers, Accidental DBA's and Managers
17mA new trend for databases: Platforms
20mTeaching elephants to fish
47mSQL Utility Belt
03mpgDay Paris 2025
46mIntro to Postgres Hacking via Temporal Tables
23mWhat I’ve Learned Teaching Postgres to 200+ field engineers at Microsoft
18mIntroducing Microsoft's VS Code Extension for PostgreSQL