Torsten Grust

Professor — likes database systems, programming languages, and SC Freiburg. ツ

@[email protected]

[DuckDB @duckdb]

🏛️ 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).

➡️ https://t.co/U3JxUvAL5M

[DuckDB @duckdb]

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 https://t.co/2U1XUYMLax for the announcement blog post and installation instructions.

[Disseminate: The Computer Science Research Podcast @DisseminatePod]

🦆 E4 S2 - Adaptive Factorization in DuckDB - with Paul Groß is out now!

You can listen on:

Spotify ➡️ https://t.co/VTCkw1kBld

Apple ➡️ https://t.co/GRNhNAkSk0

@duckdb @CWInl @cwi_da

[DuckDB @duckdb]

📢 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 https://t.co/nPg26CjxBR

[Torsten Grust @Teggy]

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

[Torsten Grust @Teggy]

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

[Torsten Grust @Teggy]

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

{⍵+1}

[DuckDB @duckdb]

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 https://t.co/dvFX7N8zfQ

[Disseminate: The Computer Science Research Podcast @DisseminatePod]

🦆 E2 S2 - Anarchy in the Database: Abigale Kim [@abigale_kim] on DuckDB and DBMS Extensibility is out now!

You can listen on:

Spotify ➡️ https://t.co/4ELG9VyrQj
YT ➡️ https://t.co/SFHugbiJJt
Apple ➡️ https://t.co/B2jCF8IFzO

[Torsten Grust @Teggy]

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

[Torsten Grust @Teggy]

@jwaudberry @DisseminatePod @duckdb There are several ways to catch the episode:

Spotify: https://t.co/wlOl3mA0fG
Apple Podcasts: https://t.co/I8I66j5hc4
YouTube: https://t.co/sUbRqnn4CM

[Torsten Grust @Teggy]

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.

[Torsten Grust @Teggy]

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.

[Disseminate: The Computer Science Research Podcast @DisseminatePod]

🦆 E1 S2 - Recursive CTEs, Trampolines, and Teaching Databases with DuckDB - with Torsten Grust (@Teggy) is out now!

You can listen on:

YT ➡️ https://t.co/SAcRZPDO9D
Spotify ➡️ https://t.co/FW3cWzk65h
Apple ➡️ https://t.co/8JGRWvVQHY

[Disseminate: The Computer Science Research Podcast @DisseminatePod]

@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... https://t.co/7MYk9cMIvG

[Disseminate: The Computer Science Research Podcast @DisseminatePod]

@Teggy @abigale_kim 🪂 E3: Mihail Stoian (@mihail_sto) - Speeding Up Queries with "Parachutes"

🧮 E4: Paul Gross - Factorized Aggregations & Worst-Case Optimal Joins

[Disseminate: The Computer Science Research Podcast @DisseminatePod]

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)

[Torsten Grust @Teggy]

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

[Torsten Grust @Teggy]

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

[Torsten Grust @Teggy]

@VfB This aged like milk.