Modern SQL: Evolution of a Dinosaur

on YouTube ↗01h 00m

" summary

Modern SQL has moved beyond pure relational constraints and now includes non-relational features like Turing-complete capabilities, graph processing, XML/JSON handling, automatic data versioning, and time-series analysis with regular expressions. The talk compares traditional relational solutions with modern SQL approaches for common problems, helping developers and architects understand current SQL capabilities and choose better designs.

AI-written summary · about

" chapters (15)

1. 0:00Welcome and introduction
2. 1:02SQL standard and chronology
3. 3:56Lateral joins explained
4. 8:28Recursive queries for hierarchies
5. 13:08Window functions overview
6. 16:21Aggregations without GROUP BY
7. 24:49Ranking functions and Top-N per groups
8. 29:51Median and sampling methods
9. 31:18MERGE for upserts
10. 35:55LIMIT and OFFSET alternatives
11. 38:30Lag and lead functions
12. 41:48Temporal databases
13. 48:27JSON support in SQL
14. 53:14Time travel with sessions and regex
15. 57:48Summary and outlook

" related talks

• 47mModern SQL: Evolution of a DinosaurMarkus Winand · International PHP Conference Spring 2019
• 48mModern SQL: Evolution of a DinosaurMarkus Winand · DevConf 2018
• 50mModern SQL: Evolution of a dinosaurMarkus Winand · Riga Dev Days 2019
• 41mModern SQL: Evolution of a dinosaurMarkus Winand · WebCamp Zagreb 2018
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Devoxx Belgium 2019
• 46mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · code.talks 2019
• 58mThe Mother of All Query Languages: SQL in the 21st CenturyMarkus Winand · Dev Day Dresden 2019
• 57mHow modern SQL databases arrive at algorithms you never dreamed ofLukas Eder · W-JAX 2018