Torsten „Teggy“ Grust
@teggy.org
Professor — like database systems, programming languages, and SC Freiburg ツ
Reposted by Torsten „Teggy“ Grust
modern-sql.com now covers DuckDB.
Modern SQL: A lot has changed since SQL-92
SQL has evolved. Beyond the relational model. Discover it now.
modern-sql.com
November 28, 2025 at 1:24 PM
modern-sql.com now covers DuckDB.
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.
October 17, 2025 at 9:16 AM
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.
Reposted by Torsten „Teggy“ Grust
Here's what we've got in store for you!
🎓 E1: Torsten Grust (@teggy.org) (University of Tübingen) - Recursive Common Table Expressions (CTEs) Demystified
🧨 E2: Abigail Kim (@abigalekim.bsky.social) (Carnegie Mellon University) - Anarchy in the Database (deep dive into DBMS Extensibility)
🎓 E1: Torsten Grust (@teggy.org) (University of Tübingen) - Recursive Common Table Expressions (CTEs) Demystified
🧨 E2: Abigail Kim (@abigalekim.bsky.social) (Carnegie Mellon University) - Anarchy in the Database (deep dive into DBMS Extensibility)
October 16, 2025 at 5:41 PM
Here's what we've got in store for you!
🎓 E1: Torsten Grust (@teggy.org) (University of Tübingen) - Recursive Common Table Expressions (CTEs) Demystified
🧨 E2: Abigail Kim (@abigalekim.bsky.social) (Carnegie Mellon University) - Anarchy in the Database (deep dive into DBMS Extensibility)
🎓 E1: Torsten Grust (@teggy.org) (University of Tübingen) - Recursive Common Table Expressions (CTEs) Demystified
🧨 E2: Abigail Kim (@abigalekim.bsky.social) (Carnegie Mellon University) - Anarchy in the Database (deep dive into DBMS Extensibility)
Reposted by Torsten „Teggy“ Grust
What if a database could be your game engine?
During parental leave @lukasvogel.bsky.social
built DOOMQL: A multiplayer DOOM-like where everything (rendering, game loop, state) runs in pure SQL on CedarDB.
It's fast, ridiculous, and surprisingly elegant.
Full write-up: cedardb.com/blog/doomql
During parental leave @lukasvogel.bsky.social
built DOOMQL: A multiplayer DOOM-like where everything (rendering, game loop, state) runs in pure SQL on CedarDB.
It's fast, ridiculous, and surprisingly elegant.
Full write-up: cedardb.com/blog/doomql
September 9, 2025 at 3:17 PM
What if a database could be your game engine?
During parental leave @lukasvogel.bsky.social
built DOOMQL: A multiplayer DOOM-like where everything (rendering, game loop, state) runs in pure SQL on CedarDB.
It's fast, ridiculous, and surprisingly elegant.
Full write-up: cedardb.com/blog/doomql
During parental leave @lukasvogel.bsky.social
built DOOMQL: A multiplayer DOOM-like where everything (rendering, game loop, state) runs in pure SQL on CedarDB.
It's fast, ridiculous, and surprisingly elegant.
Full write-up: cedardb.com/blog/doomql
Reposted by Torsten „Teggy“ Grust
Vol:18 No:12 → Democratize MATCH_RECOGNIZE!
👥 Authors: Louisa Lambrecht, Tim Findling, Samuel Heid, Marcel Knüdeler, Torsten Grust
📄 PDF: https://www.vldb.org/pvldb/vol18/p5251-lambrecht.pdf
👥 Authors: Louisa Lambrecht, Tim Findling, Samuel Heid, Marcel Knüdeler, Torsten Grust
📄 PDF: https://www.vldb.org/pvldb/vol18/p5251-lambrecht.pdf
September 2, 2025 at 10:00 PM
Vol:18 No:12 → Democratize MATCH_RECOGNIZE!
👥 Authors: Louisa Lambrecht, Tim Findling, Samuel Heid, Marcel Knüdeler, Torsten Grust
📄 PDF: https://www.vldb.org/pvldb/vol18/p5251-lambrecht.pdf
👥 Authors: Louisa Lambrecht, Tim Findling, Samuel Heid, Marcel Knüdeler, Torsten Grust
📄 PDF: https://www.vldb.org/pvldb/vol18/p5251-lambrecht.pdf
I don‘t know about you. But Whova is such a PITA.
August 31, 2025 at 9:42 AM
I don‘t know about you. But Whova is such a PITA.
Reposted by Torsten „Teggy“ Grust
🔬 We are hosting the first “DuckDB in Science” meetup in London on September 4, co-located with VLDB 2025.
🔍 We'll have two deep-dive presentations from DuckDB's developers and four lightning talks from community members.
📍 For details and registration, see duckdb.org/events/2025/...
🔍 We'll have two deep-dive presentations from DuckDB's developers and four lightning talks from community members.
📍 For details and registration, see duckdb.org/events/2025/...
August 28, 2025 at 10:03 PM
🔬 We are hosting the first “DuckDB in Science” meetup in London on September 4, co-located with VLDB 2025.
🔍 We'll have two deep-dive presentations from DuckDB's developers and four lightning talks from community members.
📍 For details and registration, see duckdb.org/events/2025/...
🔍 We'll have two deep-dive presentations from DuckDB's developers and four lightning talks from community members.
📍 For details and registration, see duckdb.org/events/2025/...
Reposted by Torsten „Teggy“ Grust
The Call for the 2026 International Symposium on Functional and Logic Programming (FLOPS) is open - the symposium will be May 26-28 in Akita, Japan. Deadline for the CfP is Dec 8 (abstracts) / Dec 16 (submissions).
Send us your best on the best of both worlds!
functional-logic.org/events/flops...
Send us your best on the best of both worlds!
functional-logic.org/events/flops...
FLOPS 2026 - Call for Papers | Functional Logic Programming
18th International Symposium on Functional and Logic Programming
functional-logic.org
August 26, 2025 at 6:52 AM
The Call for the 2026 International Symposium on Functional and Logic Programming (FLOPS) is open - the symposium will be May 26-28 in Akita, Japan. Deadline for the CfP is Dec 8 (abstracts) / Dec 16 (submissions).
Send us your best on the best of both worlds!
functional-logic.org/events/flops...
Send us your best on the best of both worlds!
functional-logic.org/events/flops...
Reposted by Torsten „Teggy“ Grust
Pleased to announce that the third edition of my PL book, PLAI, is finally available on paper! Same price as it's been for 20 years (-:. Also made it available on Kindle EPUB, and a few other options. (Always free options, of course.) Enjoy!
www.plai.org
www.plai.org
Programming Languages: Application and Interpretation
www.plai.org
July 27, 2025 at 5:25 PM
Pleased to announce that the third edition of my PL book, PLAI, is finally available on paper! Same price as it's been for 20 years (-:. Also made it available on Kindle EPUB, and a few other options. (Always free options, of course.) Enjoy!
www.plai.org
www.plai.org
Reposted by Torsten „Teggy“ Grust
This is a briljant feature!
I have actually used it to solve a challenge I faced for a customer, and it was a lot quicker than a more traditional SQL-based solution. To be fair, it was slower than an equivalent algorithmic solution.
Anyway thanks @teggy.org and @duckdb.org for contributing this!
I have actually used it to solve a challenge I faced for a customer, and it was a lot quicker than a more traditional SQL-based solution. To be fair, it was slower than an equivalent algorithmic solution.
Anyway thanks @teggy.org and @duckdb.org for contributing this!
July 10, 2025 at 7:10 PM
This is a briljant feature!
I have actually used it to solve a challenge I faced for a customer, and it was a lot quicker than a more traditional SQL-based solution. To be fair, it was slower than an equivalent algorithmic solution.
Anyway thanks @teggy.org and @duckdb.org for contributing this!
I have actually used it to solve a challenge I faced for a customer, and it was a lot quicker than a more traditional SQL-based solution. To be fair, it was slower than an equivalent algorithmic solution.
Anyway thanks @teggy.org and @duckdb.org for contributing this!
Reposted by Torsten „Teggy“ Grust
We'll host the DuckDB Berlin Meetup in two weeks with talks from Amine Mhedhbi, Marcin Rudolf and David Justen.
If you're based in Berlin or will be attending SIGMOD 2025, register at www.meetup.com/duckdb/event... and drop by!
If you're based in Berlin or will be attending SIGMOD 2025, register at www.meetup.com/duckdb/event... and drop by!
June 12, 2025 at 5:43 PM
We'll host the DuckDB Berlin Meetup in two weeks with talks from Amine Mhedhbi, Marcin Rudolf and David Justen.
If you're based in Berlin or will be attending SIGMOD 2025, register at www.meetup.com/duckdb/event... and drop by!
If you're based in Berlin or will be attending SIGMOD 2025, register at www.meetup.com/duckdb/event... and drop by!
Reposted by Torsten „Teggy“ Grust
📢 We are hosting a DuckDB meetup in Berlin during the week of the SIGMOD conference.
📍 The meetup will take place on June 26 (Thursday) south of the Tiergarten and will feature talks by Amine Mhedhbi, David Justen and dltHub!
📝 If you plan to attend, please register at duckdb.org/events/2025/...
📍 The meetup will take place on June 26 (Thursday) south of the Tiergarten and will feature talks by Amine Mhedhbi, David Justen and dltHub!
📝 If you plan to attend, please register at duckdb.org/events/2025/...
May 28, 2025 at 3:15 PM
📢 We are hosting a DuckDB meetup in Berlin during the week of the SIGMOD conference.
📍 The meetup will take place on June 26 (Thursday) south of the Tiergarten and will feature talks by Amine Mhedhbi, David Justen and dltHub!
📝 If you plan to attend, please register at duckdb.org/events/2025/...
📍 The meetup will take place on June 26 (Thursday) south of the Tiergarten and will feature talks by Amine Mhedhbi, David Justen and dltHub!
📝 If you plan to attend, please register at duckdb.org/events/2025/...
Reposted by Torsten „Teggy“ Grust
We have a guest blog post by researchers at the University of Tübingen. 🎓
In this deep dive, Björn Bamberg and Torsten Grust (@teggy.org) introduce “USING KEY”, which allows defining a key to reduce the memory usage of recursive common table expressions.
Read the post at duckdb.org/2025/05/23/u...
In this deep dive, Björn Bamberg and Torsten Grust (@teggy.org) introduce “USING KEY”, which allows defining a key to reduce the memory usage of recursive common table expressions.
Read the post at duckdb.org/2025/05/23/u...
May 22, 2025 at 7:37 PM
We have a guest blog post by researchers at the University of Tübingen. 🎓
In this deep dive, Björn Bamberg and Torsten Grust (@teggy.org) introduce “USING KEY”, which allows defining a key to reduce the memory usage of recursive common table expressions.
Read the post at duckdb.org/2025/05/23/u...
In this deep dive, Björn Bamberg and Torsten Grust (@teggy.org) introduce “USING KEY”, which allows defining a key to reduce the memory usage of recursive common table expressions.
Read the post at duckdb.org/2025/05/23/u...
Our USING KEY variant of recursive CTEs has landed in DuckDB 1.3 Formerly an off-the-beaten-path researchy idea, now available in a real off-the-shelf DBMS. Hooray! 🎉
duckdb.org/2025/05/23/u...
duckdb.org/2025/05/23/u...
USING KEY in Recursive CTEs
Recursive CTEs in SQL allow for powerful iterative queries like graph traversals but can be memory-intensive and slow due to repeated row accumulation. DuckDB’s new USING KEY feature addresses this by...
duckdb.org
May 22, 2025 at 5:54 PM
Our USING KEY variant of recursive CTEs has landed in DuckDB 1.3 Formerly an off-the-beaten-path researchy idea, now available in a real off-the-shelf DBMS. Hooray! 🎉
duckdb.org/2025/05/23/u...
duckdb.org/2025/05/23/u...
Reposted by Torsten „Teggy“ Grust
CedarDB Community Edition is here!
Download CedarDB Community Edition today - no paywall, no signup, just pure performance.
Read more about our CedarDB on our blog: cedardb.com/blog/launch/
Download CedarDB Community Edition today - no paywall, no signup, just pure performance.
Read more about our CedarDB on our blog: cedardb.com/blog/launch/
Announcing the CedarDB Community Edition
CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...
cedardb.com
May 14, 2025 at 4:07 PM
CedarDB Community Edition is here!
Download CedarDB Community Edition today - no paywall, no signup, just pure performance.
Read more about our CedarDB on our blog: cedardb.com/blog/launch/
Download CedarDB Community Edition today - no paywall, no signup, just pure performance.
Read more about our CedarDB on our blog: cedardb.com/blog/launch/
Reposted by Torsten „Teggy“ Grust
Reposted by Torsten „Teggy“ Grust
We teamed up with the Disseminate: The Computer Science Research Podcast to launch a new series called DuckDB in Research.
In the first episode, show host Jack Waudby talks to Till Döhmen about DuckDQ, a Python library for data quality checks in ML pipelines: open.spotify.com/episode/2a0b...
In the first episode, show host Jack Waudby talks to Till Döhmen about DuckDQ, a Python library for data quality checks in ML pipelines: open.spotify.com/episode/2a0b...
March 15, 2025 at 8:36 PM
We teamed up with the Disseminate: The Computer Science Research Podcast to launch a new series called DuckDB in Research.
In the first episode, show host Jack Waudby talks to Till Döhmen about DuckDQ, a Python library for data quality checks in ML pipelines: open.spotify.com/episode/2a0b...
In the first episode, show host Jack Waudby talks to Till Döhmen about DuckDQ, a Python library for data quality checks in ML pipelines: open.spotify.com/episode/2a0b...
Reposted by Torsten „Teggy“ Grust
So thrilled the DuckDB UI is out to the world!
Read the post, but wanted to also share a couple small design details we thought about in thread
Read the post, but wanted to also share a couple small design details we thought about in thread
DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/d...
March 12, 2025 at 4:31 PM
So thrilled the DuckDB UI is out to the world!
Read the post, but wanted to also share a couple small design details we thought about in thread
Read the post, but wanted to also share a couple small design details we thought about in thread
Reposted by Torsten „Teggy“ Grust
All the videos are up at www.hytradboi.com/2025#program now.
HYTRADBOI 2025
HYTRADBOI is a fun online conference about databases, programming languages, and everything in between.
www.hytradboi.com
March 1, 2025 at 6:17 AM
All the videos are up at www.hytradboi.com/2025#program now.
Reposted by Torsten „Teggy“ Grust
It's out: learningduckdb.com/newsletters/...
Learn DuckDB by example
Subscribe to the newsletter to get your dose of DuckDB tips, SQL tricks, and links to learn more about the swiss knife of analytical databases.
learningduckdb.com
March 3, 2025 at 7:25 AM
It's out: learningduckdb.com/newsletters/...
That’s my other office door.
February 28, 2025 at 11:46 AM
That’s my other office door.
Found this taped to my office door today. 😅
February 28, 2025 at 11:43 AM
Found this taped to my office door today. 😅
Reposted by Torsten „Teggy“ Grust
Please consider nominating yourself to be a member of the Board of the #Haskell Foundation: discourse.haskell.org/t/2025-call-...
2025 Call for nominations for the Haskell Foundation
Hello! everyone The Haskell Foundation’s directors are pleased to announce the nomination process for seats on the Foundation’s board of directors. The board is the ultimate decision-making body of ...
discourse.haskell.org
February 25, 2025 at 5:10 PM
Please consider nominating yourself to be a member of the Board of the #Haskell Foundation: discourse.haskell.org/t/2025-call-...