Torsten „Teggy“ Grust

Torsten „Teggy“ Grust

@teggy.org

Professor — like database systems, programming languages, and SC Freiburg ツ

682 followers184 following53 posts

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 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.

duckdb.orgAnnouncing DuckDB 2.0.0 LTS “Cinnamon Teal”The DuckDB team is happy to announce that today we're releasing DuckDB version 2.0.0 LTS, codenamed “Cinnamon Teal” (Spatula cyanoptera). This is our biggest feature release so far, and it ships a pol...

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.

duckdb.orgHow DuckDB Runs Recursive CTEs FasterDuckDB's recursive CTE engine now treats recursion as one long-lived computation: it retains eligible epoch-invariant state, chooses execution modes from exact frontier cardinalities and physical work...

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)

duckdb.orgDuckDB Boston MeetupDuckDB is an in-process SQL database management system focused on analytical query processing. It is designed to be easy to install and easy to use. DuckDB has no external dependencies. DuckDB has bin...

Torsten „Teggy“ Grust reposted

Today, we are releasing DuckDB v1.4.5 and v1.5.4. Yes, we know – these version numbers can be a bit confusing! That's why we wrote two blog posts this time. The thread helps you pick the right one 🧵

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

Today, we are releasing DuckDB v1.5.3. This is not an ordinary patch release – it packs many new features for the Quack client-server protocol, Quack support for DuckLake, and big updates for AWS, HTTPS and Iceberg. Check out our blog post about all these changes and improvements – link in the 🧵.

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!

DuckDB@duckdb.org

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

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

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!

Haskell Interlude@haskellinterlude.bsky.social

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

We are hosting the next edition of our community conference, DuckCon, in Amsterdam on June 24. The registration is already open and you can submit your talk proposals until next Wednesday. Looking forward to your submissions and seeing the flock in the summer!

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

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 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 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

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!

cs.cmu.eduDatabases in 2025: A Year in ReviewThe world tried to kill Andy off but he had to stay alive to to talk about what happened with databases in 2025.

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/

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.