Modern SQL: Evolution of a dinosaur

on YouTube ↗41m

" summary

Claims that modern SQL cuts application code by using actual database features and shows working demos: replacing multiple queries and app-side loops with window functions to compute ranks, running totals and top-N per group; using JSON support to store and query semi-structured payloads instead of dozens of columns and joins; fixing pagination with OFFSET/FETCH semantics rather than fragile LIMIT/offset hacks. Includes concrete examples, query text patterns, and notes on performance and caveats from the demos.

AI-written summary · about

" chapters (7)

1. 0:00Introduction to modern SQL
2. 4:06SQL’s evolution and analytics
3. 14:36Window functions in SQL
4. 22:51Offset and pagination in SQL
5. 28:00SQL beyond relational databases
6. 35:45SQL’s future and innovations
7. 39:13Closing and Q&A

" related talks

• 47mModern SQL: Evolution of a DinosaurMarkus Winand · International PHP Conference Spring 2019
• 01h 00mModern SQL: Evolution of a DinosaurMarkus Winand · JAX 2019
• 50mModern SQL: Evolution of a dinosaurMarkus Winand · Riga Dev Days 2019
• 48mModern SQL: Evolution of a DinosaurMarkus Winand · DevConf 2018
• 39mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Big Data Conference Europe 2019
• 57mHow modern SQL databases arrive at algorithms you never dreamed ofLukas Eder · W-JAX 2018
• 02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyFranck Pachot · Devoxx France 2023
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Devoxx Belgium 2019