Finally, Markus! 👍🏻🦆

I see what you mean. But beyond storing the movie, how would you formulate queries over 3 ✕ x ✕ y columns? Like “Remove the first and last five rows of pixels.”? Trivial in Hannes’ encoding.

There are several ways to catch the episode:

YouTube: youtu.be/Hoo0KZ6EDq0?...
Spotify: open.spotify.com/episode/3Mdb...
Apple Podcasts: podcasts.apple.com/us/podcast/r...

I'm grateful that Jack Waudby gave me the chance to set the CTE record straight on his @disseminatepodcast.bsky.social. Hear us talk about what you can do with iterative queries in SQL, how efficient variants of recursion in SQL found their way into @duckdb.org, and how trampolines come into play.

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)

www.whova.com (and app on mobile). Event „management“ service used by all the major DB conferences for some years now. By default spammy, spammy, spammy (notifications, e-mail) to a comical degree.

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!

Awesome. Time to give Materialize another spin! 🌪️

Hehe… 😅

Kudos for your work on making GTFS data readily available in DuckDB, by the way. Absolutely fabulous sample data for teaching purposes. Very motivating for students to touch data that immediately relates to their everyday life (public transport, say).

tobilg.com/handling-gtf...

Support for ON DELETE CASCADE! Yay! \o/

😉