Richer SQL — Steering SQL's Future Towards Clojure's Philosophy
summary
XTDB v2 is an open source Clojure database that implements SQL-compatible bitemporality (system time + valid time), exposes Postgres wire-compatible tooling, and compiles a simpler XQL into relational algebra. It bans interactive transactions, writes a single CFA timeline for isolation and read scaling, and stores first-class maps, sets and arrays so JSON tricks aren’t needed. The demo shows inserts, updates, as_of queries, time travel and nest_many working end-to-end.
AI-written summary · about
chapters (11)
- 0:00Introduction and context
- 1:45The state of Postgres
- 4:48Why SQL remains dominant
- 7:42Bridging SQL and Clojure values
- 11:17Lessons from Datomic
- 15:32Bitemporality in SQL
- 19:19Solving real-world reporting
- 22:45Implementing the XTDB model
- 26:54The future of SQL tooling
- 28:36Strategic questions and demo
- 31:04Concluding thoughts
related talks
01h 06mReconstructing History with XTDB
32m"State of XTDB"
05mJUXT - reClojure 2021 Sponsor
31mSQL to NoSQL to NewSQL and the rise of polyglot persistence Paul Dix
01h 07mQuestDB: Fast Open Source Time Series Database
24mRex "Doobie": A Functional JDBC That Doesn't Hide SQL
17mA new trend for databases: Platforms
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively