Modern SQL: Evolution of a Dinosaur

on YouTube ↗47m

" summary

Markus Winand shows how SQL has evolved beyond pure relational algebra since SQL-92, highlighting modern capabilities such as Turing-completeness, graph processing, XML/JSON semantics, automatic temporal versioning, and time-series analysis with regular expressions. He compares solving common problems with a traditional purely-relational approach versus using these modern SQL features so developers and architects can decide when to use each approach.

AI-written summary · about

" chapters (13)

1. 0:00Welcome
2. 2:15SQL standards evolution
3. 5:37Recent SQL features
4. 9:16Modern SQL use cases
5. 14:45Window functions
6. 18:37Ranking functions
7. 23:06Temporal tables
8. 28:10Time travel tracking
9. 32:45First JSON database
10. 36:54Logical updates
11. 40:24Document transformation
12. 43:22SQL future
13. 46:19Q&A

" related talks

• 01h 00mModern SQL: Evolution of a DinosaurMarkus Winand · JAX 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
• 58mThe Mother of All Query Languages: SQL in the 21st CenturyMarkus Winand · Dev Day Dresden 2019
• 46mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · code.talks 2019
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Devoxx Belgium 2019
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Dutch PHP Conference 2019