Let's SQL Like It's 1992!
summary
Models a turn based space game in SQL and shows concrete results using Postgres with a user plugin that implements full temporality so updates and deletes automatically archive prior rows into history tables and a date range of validity. The demo creates tables for civilizations units systems wormholes inserts example data exercises deletes and moves and verifies the history is preserved. It also computes control with window functions and exposes a materialized view that answers who controls each system.
AI-written summary · about
chapters (13)
- 0:00SQL still matters
- 1:32Data modeling hardest part
- 3:00Space game example
- 8:00SQL three languages
- 12:16Modeling civilizations
- 15:45Schemas for game data
- 22:21Active state with constraints
- 25:31Temporal modeling history
- 32:27Test data and model expansion
- 34:44Query ship positions
- 36:14Window functions for rankings
- 38:38Materialized views for queries
- 39:42Summary SQL modeling
related talks
01h 03mTemporal Database Demo
31mFuturistic SQL: Making the impossible possible
21mA Hands-on Experience with Complex SQL
42mBack to the Future! Time Travel with Bitemporal Databases
39mMore Than a Query Language: SQL in the 21st Century
25mData modeling with PostgreSQL at the core of Software Development
29mDatabase Sorcery 101 Ditch the Ancient SQL Scrolls for SQLModel
46mIntro to Postgres Hacking via Temporal Tables