Modern SQL: A lot has changed since SQL-92 by Markus Winand
Why Hacker News recommends it
Recommended as the best introduction to modern SQL standard features that textbooks skip.
What it is
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.
Recommended by 2 HN commenters across 2 different months, 2019 to 2023.
What Hacker News said
Recommends mongol · 2019-02 · on “SQL: One of the most valuable skills”
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.
Recommends scythmic_waves · 2023-01 · on “Easy, alternative soft deletion: `deleted_record_insert`”
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]
Cites jamie_ca · 2019-03 · on “Ask HN: What made you change your mind about a programming language/paradigm?”
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]