What would SQL be without recursive common table expressions (CTE)? Correct: nothing but glorified relational algebra. Recursive CTEs (and myself 😉) are on stage during the upcoming codetalks.com 2026 conference in Hamburg. Contains lots of funky SQL examples (all runnable in @duckdb.org).
Torsten „Teggy“ Grust
Torsten „Teggy“ Grust
@teggy.org
Professor — like database systems, programming languages, and SC Freiburg ツ
682 followers184 following53 posts
Torsten „Teggy“ Grust reposted
Announcing DuckDB 2.0.0 LTS “Cinnamon Teal” 🦆 This is the biggest #DuckDB feature release ever, and it's shipping a polished version of the Quack protocol for DuckDB-as-a-server, async I/O, a first-class VARIANT type, agent mode, triggers, an extensible SQL parser and more – read on for details.
Torsten „Teggy“ Grust reposted
Accepted papers are up and registration is open for CIDR 2027! January 24th-27th in Amsterdam. www.cidrdb.org/cidr2027/pap... www.cidrdb.org/cidr2027/reg...
Torsten „Teggy“ Grust reposted
The call for contributions to #BOBkonf2027 is still open for one more month! We'd love to see yours. Submission deadline is 2nd November. Find more information, check bobkonf.de/2027/cfc.html #BOBkonf
Listened to the latest episode of the Type Theory for All podcast (www.typetheoryforall.com/episodes/pl-...) which was absolutely great. Now have the following pinned on my office wall, lest I forget. Thanks, @shriram.bsky.social.
Torsten „Teggy“ Grust reposted
The #BOBkonf2027 Call for Contributions is live! We're accepting submissions until 2 November 2026. More information regarding the call can be found here: bobkonf.de/2027/cfc.html
Torsten „Teggy“ Grust reposted
[v2.0 preview:] #DuckDB’s recursive CTE engine now treats recursion as 1 long-lived computation: it retains eligible epoch-invariant state, chooses execution modes from exact frontier cardinalities and physical work, probes keyed state directly and gives `USING KEY ... UNION` changed-key semantics.
Torsten „Teggy“ Grust reposted
Quack, quack! A DuckDB v2.0 preview is here! 🦆 In this post, #DuckDB co-creators Mark Raasveldt + @hannes.muehleisen.org preview the headline features of DuckDB v2.0 (expected to land this autumn): • DuckDB as a server • Triggers • async I/O • + more Dive into the deets: duckdb.org/2026/08/17/d...
Torsten „Teggy“ Grust reposted
We’re excited to announce the #DuckDB Boston meetup, which will take place during the week of the VLDB conference. Come join the DuckDB community in Beantown for technical talks, drinks, and networking with new faces and old friends. We hope to see you there! 🦆 (Registration is required but free)
Torsten „Teggy“ Grust reposted
🦆 Announcing DuckDB 1.5.5 ! 🦆 This release includes a number of bugfixes, performance improvements, and security patches. Summary blog: duckdb.org/2026/07/22/a... Full release notes: github.com/duckdb/duckd... Thank you to all the contributors for providing detailed issue reports and patches. 💖
Torsten „Teggy“ Grust reposted
Check out the Awesome DuckDB repo – curated by @davidgasquez.com – to explore the growing list of handy tools and cool projects built around #DuckDB, DuckLake and more. 😎 🦆 Notice a great tool that’s missing? Submit a PR to get it added. Start exploring: davidgasquez.github.io/awesome-duck...
Torsten „Teggy“ Grust reposted
June 2026 issue of #SIGMODRecord is out. And so is the new issue of the Reminiscences column. Many thanks to @teggy.org (Torsten Grust), Wenjie Zhang, and Viktor Sanca for their contributions!! pdf --> sigmodrecord.org/publications...
Torsten „Teggy“ Grust reposted
🤩 DuckCon's talk slides and recordings are out!
Torsten „Teggy“ Grust reposted
Torsten „Teggy“ Grust reposted
DuckCon #7 is coming up and we're looking for sponsors. We have a lineup of 15 speakers, sharing their experiences with DuckDB. For the first time, the talks will also cover DuckLake and Quack. Check out the sponsorship packages on the conference site, duckcon.org
Torsten „Teggy“ Grust reposted
Torsten „Teggy“ Grust reposted
ORDER BY Has Come a Long Way modern-sql.com/blog/2026-05... The ORDER BY clause is surely one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. For that, the article walks you through the evolution of the ORDER BY clause the SQL standard.
Torsten „Teggy“ Grust reposted
This Tuesday, Hannes announced Quack, our new protocol that turns DuckDB into a client-server database. Watch his talk, recorded at the AI Council, where he explained how Quack works in practice, what stack it's built on, how it performs, and what our long-term ambitions are. youtu.be/L_lttD-d1wc
Torsten „Teggy“ Grust reposted
Torsten „Teggy“ Grust reposted
I've been working on organizing our next DuckCon for the past three months. The program is finally out and I think we have a really strong lineup, featuring speakers from ETH Zürich, Spotify, MariaDB, the Merck Group, Snowflake, Foursquare, and more. Join us in Amsterdam on June 24!
The program for DuckCon #7 is out! Here's the gist: – State of the Duck: DuckLake v1.0 + a super-secret new feature – Six regular talks (incl. one from Spotify) – Six lightning talks (incl. Toyota Gazoo WRT) – Drinks & snacks and time to socialize 🧵 Full program and registration link in the thread
Torsten „Teggy“ Grust reposted
Flattered that the good FP folks put up with me as a DB guy. Thank you for the chat, @kosmikus.bsky.social and @sperbsen.bsky.social. What a fun hour to spend!
We sat down with Torsten Grust who is a professor of DB systems at the University of Tübingen. We talked about the best way to program databases, how to bridge the gap between regular programming languages and databases, and compiling just about everything to SQL. haskell.foundation/podcast/81/
Torsten „Teggy“ Grust reposted
Torsten „Teggy“ Grust reposted
🇳🇱 DuckCon returns to the Netherlands! We'll host our next edition on June 24 in Amsterdam. We are looking forward to meeting the DuckDB community in our home town's Royal Tropical Institute for an afternoon of talks and discussions. Please submit your talk proposals and register! duckcon.org
Torsten „Teggy“ Grust reposted
🚨 "AnyBlox: A Framework for Self-Decoding Datasets" with Mat Gienieczko (@gienieczko.com) is available now! Watch on YouTube ➡️ youtu.be/2YwC_GVvxgA?... Listen on Spotify ➡️ open.spotify.com/episode/1YAf... Listen on Apple ➡️ podcasts.apple.com/us/podcast/m...
Torsten „Teggy“ Grust reposted
Wie oft es wohl Patt, Punkteteilung oder Gleichstand gab? 🤔 @scfreiburg.com #nurderSCF
Torsten „Teggy“ Grust reposted
We released DuckDB v1.5! This release comes with a “friendly CLI” client, a new (opt-in) PEG parser, support for VARIANT types and many lakehouse features. It also ships a new network stack, a reworked geospatial extension, Azure writes and an ODBC scanner. Read more at duckdb.org/2026/03/09/a...
Torsten „Teggy“ Grust reposted
🗓️ This year, we came up with new merchandise: the 2026 Friendly DuckDB calendar, which has a SQL feature for every month along with art inspired by the feature. ⬇️ If you were lucky to get one at our events, that's great! :) If not, you can still grab the PDF at blobs.duckdb.org/merch/duckdb...
Torsten „Teggy“ Grust reposted
🌏 We are happy to announce the first DuckCon in the APAC region: DuckCon #7 will take place in the National Gallery Singapore on 2026-05-05. 🗳️ Registration and the Call for Talks are open! Submit your proposals until 2026-03-18. ➡️ duckdb.org/events/2026/...
Torsten „Teggy“ Grust reposted
🏗️ The DuckDB team is working hard on delivering DuckDB v1.5. 🌃 While the official release is next week, you can already give it a quick test using the nightly builds available at duckdb.org/install/prev... If you encounter any issues, let us know! 🐛💬
Torsten „Teggy“ Grust reposted
🦆 ↔️ 🦀 DuckDB Labs is looking for a Rust engineer to join our team in Amsterdam. 📝 See the details and application page at duckdblabs.com/jobs/rust_en...
Torsten „Teggy“ Grust reposted
The ArrayCast is back and now it's broadcast live! Join Conor Hoekstra, Adám Brudzewsky, and guests. The next episode, "FIXAPL with Jacob Lockwood", will take place on Monday 16 February at 15:00 UTC – see www.youtube.com/@arraycast/ #APL #ArrayProgramming #ArrayCast
Torsten „Teggy“ Grust reposted
🎞️ The slide decks and talk recordings of last Friday's developer meeting are out! duckdb.org/events/2026/...
Torsten „Teggy“ Grust reposted
📆 The DuckDB Developer Meeting in Amsterdam starts tomorrow! We'll have a deep-dive extension development workshop in the morning and four exciting talks in the afternoon. 🎟️ Last chance to register at duckdb.org/events/2026/...
Torsten „Teggy“ Grust reposted
Please help us publicize TEAL: Tools for Educational Activities in Logic, a workshop associated w/ FLoC26. We have a novel design, focused on demos, discussion, and generally high-quality interaction rather than weak papers. See full details on our site! teal.cs.brown.edu/floc2026/
Torsten „Teggy“ Grust reposted
We are going to hold the first DuckDB Developer Meeting in two weeks in Amsterdam! On the day of the meeting, DuckDB Community Extensions development champion Rusty Conover will also give a workshop on DuckDB extension development. Check out the programme and sign up at duckdb.org/events/2026/...
Torsten „Teggy“ Grust reposted
I've posted my latest recap of the world of databases: www.cs.cmu.edu/~pavlo/blog/... All the hot topics from the last year: • More Postgres action! • MCP for everyone! • MongoDB gets litigious with FerretDB! • File formats! • Market movements! • The richest person in the history of the world!
Torsten „Teggy“ Grust reposted
🏛️ 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/
Torsten „Teggy“ Grust reposted
I'm grateful that Jack Waudby gave me the chance to set the CTE record straight on his @disseminatepodcast.bsky.social. Hear us talk about what you can do with iterative queries in SQL, how efficient variants of recursion in SQL found their way into @duckdb.org, and how trampolines come into play.
There are several ways to catch the episode: YouTube: youtu.be/Hoo0KZ6EDq0?... Spotify: open.spotify.com/episode/3Mdb... Apple Podcasts: podcasts.apple.com/us/podcast/r...