hackertube.io

How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder

Devoxx · talk · Watch on YouTube

Databases & storage

What it is

Lukas Eder's Devoxx talk on how modern cost-based SQL optimizers rewrite and plan queries in ways developers would not expect. It argues that declarative SQL, used well, can run complex queries very fast.

Why Hacker News recommends it

HN commenters recommend it to developers unfamiliar with how much leverage and intelligence there is in a SQL database.

  • 3 people recommended it
  • 3 different months
  • 0 strong recommendations
  • first 2019, last 2023

What HN commenters said

  1. “This is a good talk about how smart SQL query engines are.”

    How smart SQL query engines are

    nerdbaggy, 2020-05 · Recommendation · in “Medium-hard SQL interview questions”

  2. “I'd suggest watching this video to get a flavor of how much leverage using the database can give you”

    Shows leverage gained from using the database

    loudlambda, 2022-02 · Recommendation · in “A Hairy PostgreSQL Incident”

  3. “I tend to recommend my famous talk to such developers”

    Author recommends own talk to developers unfamiliar with SQL

    lukaseder, 2023-09 · Recommendation · in “Permazen: Language-natural persistence to KV stores”

Excerpts from Hacker News comments, linked to the originals. Summaries and labels were written by a language model from those comments.

Topics: sql, query optimizer, databases, postgresql, declarative programming

Also recommended by the same people