Modern SQL: A lot has changed since SQL-92 by Markus Winand
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.
Why Hacker News recommends it
Recommended as the best introduction to modern SQL standard features that textbooks skip.
- 2 people recommended it
- 2 different months
- 0 strong recommendations
- first 2019, last 2023
What HN commenters said
“I recommend you look at one of Markus Winand's presentations”
Summarizes the modern foundation of SQL databases.
mongol, 2019-02 · Recommendation · in “SQL: One of the most valuable skills”
“the whole talk is good”
Talk on interesting SQL standard additions since 92.
scythmic_waves, 2023-01 · Recommendation · in “Easy, alternative soft deletion: `deleted_record_insert`”
Excerpts from Hacker News comments, linked to the originals. Summaries and labels were written by a language model from those comments.
Topics: sql, sql standard, window functions, system versioning, databases
Also recommended by the same people
talk"Testing Distributed Systems w/ Deterministic Simulation" by Will WilsonStrange Loop Conference · 12 HN recommenders · 2014–2024
talkThe Value of Values with Rich HickeyInfoQ · 10 HN recommenders · 2014–2023
talkAWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)Amazon Web Services · 12 HN recommenders · 2019–2025
talk"Turning the database inside out with Apache Samza" by Martin KleppmannStrange Loop Conference · 9 HN recommenders · 2015–2025
talkConflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016GOTO Conferences · 3 HN recommenders · 2017–2020
lecture01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)CMU Database Group · 6 HN recommenders · 2020–2023
talkIntroduction to NoSQL • Martin Fowler • GOTO 2012GOTO Conferences · 6 HN recommenders · 2015–2021
talkRich Hickey rants about HttpServletRequest in 1080p: Death By Specificity from Clojure Made SimpleFred Overflow · 5 HN recommenders · 2020–2026