Skip to content
HomeVideos
AllLongsCategoriesPlaylists
BooksBlogsPodcasts
HistoryListsWatch laterLiked videosFollowing

The videos, books, blogs and podcasts Hacker News keeps recommending, all in one place.

VideosBooksBlogsPodcastsAboutPrivacySettings

Data from Hacker News, HackerTube, HackerBooks, HackerBlogs and Open Library. Credits · Not affiliated with Y Combinator.

HomeVideosBooksBlogsPodcasts
Ctrl K

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

    Devoxx

    2 HN recommenders · recommended in 3 months, 2019–2023

    YouTube

    55:06 · 5.5K views · Mar 27, 2018

    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 as the best introduction to modern SQL standard features that textbooks skip.

    Systems, Networks & SecurityDatabases & storage
    1. 50:31
      How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas EderDevoxx55K views • 9 years ago
    2. 54:52
      Introduction to NoSQL • Martin Fowler • GOTO 2012GOTO Conferences1M views • 13 years ago
    3. 1:06:24
      Rich Hickey: Deconstructing the DatabaseInfoQ106K views • 14 years ago
    4. 59:56
      AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)Amazon Web Services468K views • 7 years ago
    5. 39:00
      SQLite: Protégé of PostgreSQLAndrea Ross7.9K views • 12 years ago
    6. 51:02
      An Introduction to SQLiteGoogle TechTalks80K views • 19 years ago
    7. 1:01:45
      Four Languages from Forty Years Ago - Scott WlaschinNDC Conferences33K views • 8 years ago
    8. 50:23
      Old Is the New New • Kevlin Henney • GOTO 2018GOTO Conferences125K views • 8 years ago
    9. 10:48
      PHP doesn't suck (anymore)Aaron Francis223K views • 3 years ago
    10. 54:25
      Event Sourcing • Greg Young • GOTO 2014GOTO Conferences102K views • 11 years ago
    11. 42:31
      "Datafun: a functional query language" by Michael ArntzeniusStrange Loop Conference9.2K views • 9 years ago
    12. 47:43
      "Turning the database inside out with Apache Samza" by Martin KleppmannStrange Loop Conference206K views • 12 years ago
    13. 59:21
      A Crash Course in Modern Hardware by Cliff ClickDevoxx21K views • 9 years ago
    14. 52:54
      Rust at speed — building a fast concurrent databaseJon Gjengset225K views • 7 years ago
    15. 31:44
      The Value of Values with Rich HickeyInfoQ145K views • 14 years ago
    16. 46:37
      Zebras All the Way Down - Bryan Cantrill, Uptime 2017Code & Supply49K views • 9 years ago
    17. 1:03:31
      Brian Goetz - Stewardship: the Sobering PartsClojureTV39K views • 11 years ago
    18. 59:58
      SQLite: The Database at the Edge of the Network with Dr. Richard HippMethod82K views • 11 years ago
    19. 34:10
      Anders Hejlsberg on Modern Compiler ConstructionKasper25K views • 9 years ago
    20. 59:13
      AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)AWS Events115K views • 6 years ago

    3 comments from Hacker News

    1. @scythmic_wavesJan 2023· in “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]

      RecommendsView on HN
    2. @mongolFeb 2019· in “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.

      RecommendsView on HN
    3. @jamie_caMar 2019· in “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

      CitesView on HN