Torsten „Teggy“ Grust
@teggy.org
Professor — like database systems, programming languages, and SC Freiburg ツ
Reposted by Torsten „Teggy“ Grust
🎞️ The slide decks and talk recordings of last Friday's developer meeting are out! duckdb.org/events/2026/...
February 2, 2026 at 4:08 PM
🎞️ The slide decks and talk recordings of last Friday's developer meeting are out! duckdb.org/events/2026/...
Reposted by Torsten „Teggy“ Grust
📆 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/...
🎟️ Last chance to register at duckdb.org/events/2026/...
January 29, 2026 at 2:41 PM
📆 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/...
🎟️ Last chance to register at duckdb.org/events/2026/...
Reposted by Torsten „Teggy“ Grust
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/
teal.cs.brown.edu/floc2026/
TEAL 2026: Tools for Educational Activities in Logic
teal.cs.brown.edu
January 20, 2026 at 2:56 PM
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/
teal.cs.brown.edu/floc2026/
Reposted by Torsten „Teggy“ Grust
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/...
Check out the programme and sign up at duckdb.org/events/2026/...
January 16, 2026 at 3:43 PM
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/...
Check out the programme and sign up at duckdb.org/events/2026/...
Reposted by Torsten „Teggy“ Grust
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!
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!
Databases in 2025: A Year in Review
The world tried to kill Andy off but he had to stay alive to to talk about what happened with databases in 2025.
www.cs.cmu.edu
January 5, 2026 at 2:14 PM
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!
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!
The second derivative of smile is indifference.
January 4, 2026 at 1:10 PM
The second derivative of smile is indifference.
Reposted by Torsten „Teggy“ 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 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/
December 19, 2025 at 6:26 PM
🏛️ 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 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/
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/