How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder
Channel:Devoxx · Length:50:30 · Published:2017-03-02 · Views:55307
Summary
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 recommends it
HN commenters recommend it to developers unfamiliar with how much leverage and intelligence there is in a SQL database.
I'd suggest watching this video to get a flavor of how much leverage using the database can give you — HN, 2022
Subtitles (excerpt)
[Music] Welcome everybody to the main act of this conference as every time when the Java conferences finally convert to the SQL talk everyone is listening because that's something you can use every day and you will love it. How modern SQL databases come up with algorithms that you would have never dreamed of. And I'm going to keep this on a high level because SQL is a very sophisticated language. We can go very very deep into it. But during the couple of last years, last couple of years, when I was talking about SQL, mostly in the context of the Juke product that we're selling, I noticed that a lot of Java developers don't know how SQL works. Not just the syntax and the overall kind of feeling of relational algebra, but what happens behind the scene. And this talk is going to be about that. And it is, if this title is too long for you, this title will do it as well. You will walk out of this room and think I want to do everything with SQL because you are here because you think this cannot be true, right? SQL 2017, this must not be true. And by the end of the talk, is it true though? And you're leaving this room, oh my god, I'm going to rewrite all my code to SQL. Myself, I'm Lucas. I'm involved with uh Java and SQL and the Swiss community.
On Hacker News
> 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, 2023-09
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 give you: [VIDEO] If the database can make you more productive and more efficient and make your life easier, you now have incentive to … — loudlambda, 2022-02
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, 2020-05
>Totally agree. Lukas Eder has some nice presentations about it. Thanks for the shout out! For the record, that's probably the referenced talk: [VIDEO] — lukaseder, 2022-08
> further, afaik there's no assignment nor iteration in SQL That was until CTEs were introduced in SQL:1999 > it's not a programming language at all. It's a.. query language. The two are not mutually exclusive. SQL is used to tell a computer what to do, and it is very powerful at it: [VIDEO] — taffer, 2019-11
Related videos
- "Testing Distributed Systems w/ Deterministic Simulation" by Will Wilson · Strange Loop Conference · 40:20
- The Value of Values with Rich Hickey · InfoQ · 31:43
- AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401) · Amazon Web Services · 59:56
- "Turning the database inside out with Apache Samza" by Martin Kleppmann · Strange Loop Conference · 47:42
- Conflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016 · GOTO Conferences · 51:35
- 01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019) · CMU Database Group · 1:06:44
- Introduction to NoSQL • Martin Fowler • GOTO 2012 · GOTO Conferences · 54:51
- Rich Hickey rants about HttpServletRequest in 1080p: Death By Specificity from Clojure Made Simple · Fred Overflow · 4:56
- TigerStyle! (Or How To Design Safer Systems in Less Time) by Joran Dirk Greef · TigerBeetle · 1:01:59
- Bryan Cantrill from Joyent on Manta: internet-facing object storage facility that features compute · AI Council · 1:31:05
- Michael Stonebraker | Big Data is (at least) Four Different Problems · Michigan Engineering · 55:53
- "I See What You Mean" by Peter Alvaro · Strange Loop Conference · 52:29
- Zebras All the Way Down - Bryan Cantrill, Uptime 2017 · Code & Supply · 46:36
- ZFS: The Last Word in File Systems Part 1 · Deirdré Straughan · 1:01:26
- Breakout Session Presented by Dan Robinson of Heap at PGConf Silicon Valley 2015 · Citus Data · 54:53
- How We've Scaled Dropbox · Stanford · 1:08:16