Beyond WHERE and GROUP BY
summary
Shows which MariaDB SQL features to actually use and what they do: recursive CTEs for graph traversal (friend-chain/BFS example and Fibonacci/date generation), window functions turning quadratic correlated-subquery scans into linear accumulators (running totals and top‑3 transactions per user), system‑versioned tables for time travel queries (restore or audit row state at a timestamp), and JSON + user-defined aggregate functions for complex aggregates. Claims speedups of tens of times; notes optimizer tradeoffs around materializing CTEs versus merging and when temporary tables inflate results.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:33GROUP BY operations
- 8:17Recursive queries
- 15:01Window functions
- 24:42Versioned tables
- 29:00Working with JSON
- 33:18Q&A
related talks
34mCommon Table Expressions and Window Functions simple, maintainable, fast queries
50mJOIN "My Session" ON Modern = 'SQL'
45mSELECT 'amazing_features' FROM "postgresql"
01mWindowing Functions for Database Analytics
01h 00mComplex Queries with Modern SQL
49mSELECT 'amazing features' FROM "postgresql"
27mAnalytical Queries in MySQL
19mSet operations UNION, INTERSECT, and EXCEPT in MariaDB