6K views · Mar 27, 2018 · 55:06 · 2 HN recommenders · 3 mentions · discussed 2019–2023
Markus Winand shows how SQL has evolved since SQL-92, comparing old-style solutions to modern features such as window functions and system versioning, and notes that many developers never learn them.
Why Hacker News points people here: Recommended as the best introduction to modern SQL standard features that textbooks skip.
“the whole talk is good”HN comment, 2023
“I recommend you look at one of Markus Winand's presentations”
Summarizes the modern foundation of SQL databases.
I recommend you look at one of Markus Winand's presentations, such as this one : this video I felt it summarized well the modern foundation of SQL databases.
“the whole talk is good”
Talk on interesting SQL standard additions since 92.
I happened to fall down this rabbit hole a few days ago because of another HN thread. In it, a commenter mentioned [1] a talk by Markus Winand where he goes over some of the more interesting additions to the SQL standard since 92, including versioned tables [2] (I've linked to the timestamp, but the whole talk is good). I got real excited about that feature because I could think of a few tables at work that could use it. Sadly, PostgreSQL doesn't implement it [3] (I can't permalink to the feature but you can search for "T180", "System-versioned tables", "T181", or "Application-time period tables"). [1] link [2] this video [3] link
“part of SQL 2011 called System Versioning”
Talk covers SQL:2011 system versioning support across databases.
That feature's "coming" - part of SQL 2011 called System Versioning, currently supported in DB2 and SQL Server, but available in MariaDB 10.3 Beta according to this talk: this video
