HackerTube

THE VIDEO SHELF · sql query optimization

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

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 HN readers recommended it

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

This is a summary from the source dataset, not an endorsement by Hacker News or the video creator.

Video & recommendation details

Creator / channel
Devoxx
Topic
sql query optimization
Format
talk
Level
intermediate
HN recommenders in dataset
3
HN mentions in dataset
6
Recommendation years in dataset
2019–2023

These counts and years describe the included Hacker News records; they are not YouTube views or the video’s publication date.

From the original HN conversations

Excerpts from the recorded comments. Follow each source for the full comment and surrounding discussion.

  • I use to think that too. This is a good talk about how smart SQL query engines are. It is an hour though [VIDEO]

    nerdbaggy on Hacker News · 2020-05
    In Medium-hard SQL interview questions
  • I would suggest that learning SQL (the syntax) isn't the crux--it's just syntax you learn over time based off need, just like learning python--what you need is motivation. I'd suggest watching this video to get a flavor of how much leverage using the database can …

    loudlambda on Hacker News · 2022-02
    In A Hairy PostgreSQL Incident
  • > This may be more intuitive for some developers, especially those that don't use SQL all the time. I tend to recommend my famous talk to such developers: [VIDEO]

    lukaseder on Hacker News · 2023-09
    In Permazen: Language-natural persistence to KV stores

Summaries, classifications and recommendation records are from the HackerTube source dataset. Read about this library and its limitations.