HackerTube.dev

Modern SQL: A lot has changed since SQL-92 by Markus Winand

Devoxx · 5.5K views · 2018-03-27 · 55:06

Open on YouTube ↗

If playback is restricted in your region, try opening the original video. Use Mark watched to add it to your marked videos.

Overview

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.

On Hacker News

Recommended as the best introduction to modern SQL standard features that textbooks skip.

Recommended by 2 HN people across 2 months · HN mentions 2019–2023

Topics

Databases & storage
Search by tags
sqlsql standardwindow functionssystem versioningdatabases

What people said

scythmic_waves · 2023-01 · Recommendation

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] [VIDEO] [3] [LINK]

Read the original HN comment ↗
mongol · 2019-02 · Recommendation

I recommend you look at one of Markus Winand's presentations, such as this one : [VIDEO] I felt it summarized well the modern foundation of SQL databases.

Read the original HN comment ↗
jamie_ca · 2019-03 · Reference

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: [VIDEO]

Read the original HN comment ↗

Sources

Video by Devoxx, played through YouTube.

Data and selection notes

HN summaries and labels may contain AI errors. HN dates refer to discussions, not video publication.

HN Library: HackerTube export (2026-10-31) and open-index/hacker-news. Upstream summaries and classifications may contain AI errors.

Views, duration and playback status refresh separately from the published catalog. When an update fails, existing data remains visible.

Selection checks
  • SaaS & AI candidates: Topic keywords do not match
  • Editor-approved picks: Editorial review is required

Rule matches identify candidates. They do not guarantee video quality or financial results.

About the library and its sources