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!

The second derivative of smile is indifference.

🏛️ 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/

On the south stand again! #scf

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.

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)

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

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

I don‘t know about you. But Whova is such a PITA.

🔬 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/...

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

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

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!

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!

📢 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/...

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

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

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/

𝑬𝒖𝒓𝒐𝒑𝒂 wir kommen! ❤️

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

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

All the videos are up at www.hytradboi.com/2025#program now.

It's out: learningduckdb.com/newsletters/...

That’s my other office door.

Found this taped to my office door today. 😅

Please consider nominating yourself to be a member of the Board of the #Haskell Foundation: discourse.haskell.org/t/2025-call-...

If you spend your days staring at DuckDB's EXPLAIN output, you may find our DuckDB execution plan visualizer helpful (which we have derived from DALIBO's PostgreSQL-specific PEV2, built on Alex Tatiyant's excellent PEV). In its early stages, but already workable: db.cs.uni-tuebingen.de/explain/

New blog post by @hannes.muehleisen.org and @markraasveldt.bsky.social: Runtime-Extensible SQL Parsers Using PEG duckdb.org/2024/11/22/r... This post discusses how parsers in DBMSs could be re-designed using Parser Expression Grammars for extensibility and improved error reporting.

At cwi.nl/en/events/dijkstra-awards/cwi-lectures-dijkstra-fellowship we awarded the Dijkstra Fellowship to Marcin Zukowski for his contributions to DB architecture in a full room & great speakers: Allison Lee, Viktor Leis, @andypavlo.bsky.social @hannes.muehleisen.org @madelonhulsebos.bsky.social

I made a DuckDB starter pack DM me if you should be on it! go.bsky.app/8jPCfvb