Torsten Grust

🏛️ We launched the DuckDB Library: a curated collection of papers, podcasts, talks and books about DuckDB. 📚 We already have a collection of almost one hundred entities. The thumbnails show whether a piece is from the DuckDB team (yellow) or from others (purple). ➡️ duckdb.org/library/

We are happy to announce DuckDB v1.4.3 LTS, our latest patch release. Along with bugfixes, this release ships native extensions and Python support for Windows ARM64. Head to duckdb.org/2025/12/09/ann… for the announcement blog post and installation instructions.

🦆 E4 S2 - Adaptive Factorization in DuckDB - with Paul Groß is out now! You can listen on: Spotify ➡️ open.spotify.com/episode/20kzbf… Apple ➡️ podcasts.apple.com/us/podcast/ada… @duckdb @CWInl @cwi_da

📢 The final episode of DuckDB in Research's second season is out! ➗ This week, host Jack Waudby interviews Paul Groß, PhD student at CWI Amsterdam, to explore his work on adaptive factorization and worst-case optimal joins. 🎧 Listen to the episode at duckdb.org/science/paul-g…

@julianhyde @mlajtos_mu I have always been a fan of Haskell’s rather lightweight notation. The \ is visually close to λ and the language accepts λx -> x + 1, too (liked and used by many of my students).

@Teggy @mlajtos_mu By the way, since you’ve done a lot of work on lambdas and IIRC haven’t designed a language (therefore don’t have a dog in this race) I’m curious which language has your favorite lambda syntax.

Lambda syntax varies widely across languages; more widely, I think, than other language features. I wish it weren't so. It's difficult to see the elegance in a new language if the syntax is unfamiliar.

@julianhyde Woops, too late. 🙃 Well done, Julian.

@julianhyde You could add APL with its dfn ("deefun") syntax—added to APL in 1996—to that list: {⍵+1}

There's a new DuckDB episode from the @DisseminatePod. In S02E02, host Jack Waudby interviews @abigale_kim Kim, a PhD student at the University of Wisconsin-Madison on anarchy in database extensions. 🎧 Listen to the full episode at duckdb.org/science/abigal…

🦆 E2 S2 - Anarchy in the Database: Abigale Kim [@abigale_kim] on DuckDB and DBMS Extensibility is out now! You can listen on: Spotify ➡️ open.spotify.com/episode/5E5vpZ… YT ➡️ youtu.be/fJVmx8nEWNo?si… Apple ➡️ podcasts.apple.com/us/podcast/ana…

@MarindeParis14 @duckdb @DisseminatePod That’s absolutely great to hear, François. Glad to know that there was something in it for you.

@duckdb @DisseminatePod @Teggy Great talk, thank Torsten! I have a way better grasp of both the functional and performance implications of the recent ON KEY stuff. Let us NOT forget the superb questioning by Jack Waudby which made the relatively complex subject a pleasure to hear.

The @DisseminatePod's “DuckDB in Science” edition is back for a second season! In S02E01, host Jack Waudby interviews Torsten Grust (@Teggy). Torsten is a professor at the University of Tübingen and has been using DuckDB in teaching, research, and solving Advent of Code programming puzzles. In this episode, he shares his insights about recursive CTEs, trampoline-style queries and teaching databases with DuckDB. You can listen the podcast on all major platforms: – Apple Podcasts – podcasts.apple.com/us/podcast/rec… – Spotify – open.spotify.com/episode/3MdbbJ… – YouTube – youtu.be/Hoo0KZ6EDq0?si…

@jwaudberry @DisseminatePod @duckdb There are several ways to catch the episode: Spotify: open.spotify.com/episode/3MdbbJ… Apple Podcasts: podcasts.apple.com/us/podcast/rec… YouTube: youtu.be/Hoo0KZ6EDq0?si…

I'm grateful that @jwaudberry gave me the chance to set the CTE record straight on his @DisseminatePod. Hear us talk about what you can with iterative computation in SQL, how efficient variants of recursion in SQL found their way into @duckdb, and how trampolines come into play.

SQL's recursive common table expressions (CTEs) have a questionable reputation: verbose, awkward to read, inefficient to evaluate, ungrokkable semantics, ripe with arbitrary syntactic restrictions, and basically stale for 25 years now (since their advent in SQL:1999). Ugh.

🦆 E1 S2 - Recursive CTEs, Trampolines, and Teaching Databases with DuckDB - with Torsten Grust (@Teggy) is out now! You can listen on: YT ➡️ youtu.be/Hoo0KZ6EDq0?si… Spotify ➡️ open.spotify.com/episode/3MdbbJ… Apple ➡️ podcasts.apple.com/us/podcast/rec…

@Teggy @abigale_kim @mihail_sto CORRECTION: Mihail is doing his PhD at the Data Systems Lab at TU Nuremberg with Andreas Kipf (@andreaskipf) not TU Munich like I say in the trailer 👀 Sneaky plug for Andreas's High Impact in Databases episode... open.spotify.com/episode/5r2v2n…

@Teggy @abigale_kim 🪂 E3: Mihail Stoian (@mihail_sto) - Speeding Up Queries with "Parachutes" 🧮 E4: Paul Gross - Factorized Aggregations & Worst-Case Optimal Joins

Here's what we've got in store for you! 🎓 E1: Torsten Grust (@Teggy) - Recursive Common Table Expressions (CTEs) Demystified 🧨 E2: Abigail Kim (@abigale_kim) - Anarchy in the Database (deep dive into DBMS Extensibility)

@sqldaily One man's first row, is another woman's last row.

Got unaggregated columns you want to include in the SELECT list, but not the GROUP BY? You can use ANY_VALUE, e.g.: SELECT c1, ANY_VALUE ( c2 ), COUNT ... FROM ... GROUP BY c1 This returns the value from a random row (it's optimized to return the first) => non-deterministic

@IAmMrMagoo Uh, competing against Mark... poor AI. 😅 Congratulations, Mark! 🎉

The Times thetimes.com/puzzles/quizze… points out that humans can still do something better than #AI , just.

@VfB This aged like milk.

Hang it in the Louvre. 🤯 #VfB | #Bundesliga | #SCFVfB | #Demirovic