Recursive CTEs, Trampolines, and Teaching Databases with DuckDB

https://is1-ssl.mzstatic.com/image/thumb/Podcasts112/v4/ae/c7/e6/aec7e688-ddb0-dfd7-d3cc-3393afc2f780/mza_15193391861174205842.jpeg/600x600bb.jpg

Disseminate: The Computer Science Research Podcast

Jack Waudby

87 episodes

6 days ago

This podcast features interviews with Computer Science researchers. Hosted by Dr. Jack Waudby researchers are interviewed, highlighting the problem(s) they tackled, solutions they developed, and how their findings can be applied in practice. This podcast is for industry practitioners, researchers, and students, aims to further narrow the gap between research and practice, and to generally make awesome Computer Science research more accessible. We have 2 types of episode: (i) Cutting Edge (red/blue logo) where we talk to researchers about their latest work, and (ii) High Impact (gold/silver logo) where we talk to researchers about their influential work.

You can support the show through Buy Me a Coffee. A donation of $3 will help us keep making you awesome Computer Science research podcasts.

Hosted on Acast. See acast.com/privacy for more information.

All content for Disseminate: The Computer Science Research Podcast is the property of Jack Waudby and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

You can support the show through Buy Me a Coffee. A donation of $3 will help us keep making you awesome Computer Science research podcasts.

Hosted on Acast. See acast.com/privacy for more information.

Recursive CTEs, Trampolines, and Teaching Databases with DuckDB - with Prof. Torsten Grust

Disseminate: The Computer Science Research Podcast

51 minutes 5 seconds

2 weeks ago

Recursive CTEs, Trampolines, and Teaching Databases with DuckDB - with Prof. Torsten Grust

In this episode of the DuckDB in Research series, host Dr Jack Waudby talks with Professor Torsten Grust from the University of Tübingen. Torsten is one of the pioneers behind DuckDB’s implementation of recursive CTEs.

In the episode they unpack:

The power of recursive CTEs and how they turn SQL into a full-fledged programming language.
The story behind adding recursion to DuckDB, including the using key feature and the trampoline and TTL extensions emerging from Torsten’s lab.
How these ideas are transforming research, teaching, and even DuckDB’s internal architecture.
Why DuckDB makes databases exciting again — from classroom to cutting-edge systems research.

If you’re into data systems, query processing, or bridging research and practice, this episode is for you.

Links:

Hosted on Acast. See acast.com/privacy for more information.