When #DuckDB-Wasm# was launched in 2021, databases could not be persisted: everything lived in the Wasm heap and vanished when the tab closed. Keeping data meant serializing tables to Parquet, storing the bytes in IndexedDB, and re-registering them on the next page load. This was doable, but had to be handled at the application layer and was not offered out of the box by DuckDB-#Wasm#. Modern browsers now ship the Origin Private File System (OPFS), a per-origin, sandboxed file system with random-access reads and writes. DuckDB-Wasm can use it as a storage backend. This post by @carlo_piovesan and @GeertjanW shows you how:

DuckDB Monthly #45# is out. Spotlight: Vladimir Gribanov, creator of the DuckDB MSSQL extension (native TDS, no ODBC). His bulk-load tuning took 38M rows into SQL Server from 933s to 96s. Plus DuckLabs joins AWS, MotherDuck acquires Tower, and v2.0-alpha lands.

DuckDB 2.0 rewrote recursive CTEs. Walking a 20,000-commit git history: 1.8 to 16 s on 1.5.5, 0.10 s on 2.0, every run. 1.5: re-read the whole table every round. 2.0: read once, build a lookup, touch only the frontier's rows. Deep parent/child chains are where it shows.

DuckDB 2.0 alpha reads Parquet and CSV from S3 2x to 3x faster, with zero query changes. 1.5: each worker downloads, waits, decodes, repeats. 2.0: a download pool fetches ahead, workers only decode. Same laptop, same query: 18.8 s to 7.7 s. On by default. Full numbers, plus recursive CTEs and VARIANT:

2022 plan: hack on DuckDB, learn Rust. What happened instead: investors funded the company before there was one. Our CEO Jordan Tigani on Beyond Coding with @PatrickAkil_ — Giving DuckDB Labs co-founder shares, two years to a product people would pay for, and whether dashboards survive the age of agents.

What’s Next for DuckDB? 🦆🤔 Hannes Mühleisen, co-creator of DuckDB, was recently interviewed by Kris Jenkins of the Developer Voices podcast on every challenge, reward, twist, and turn of building a database as popular as DuckDB. From the early days of the product to the most recent acquisition of @ducklabs_com by @awscloud, Hannes – and what it means for the future of the open source DuckDB, DuckLake, and Quack projects*. It’s an interview as much as a story – an odyssey of what it means to build not only an open source product, but also a community, a company, and what success looks like in the day to day journey along the way. 📺 Watch the video episode (or read the transcript) here: 🎧 Or, listen wherever you get your podcasts. *Spoilers: DuckDB, DuckLake, Quack, and other open source projects in the DuckStack will remain open source and the project’s intellectual property, MIT license, and trademark are controlled by the DuckDB Foundation. The DuckLabs company is joining AWS, but the OSS projects remain OSS and controlled solely by the Foundation. 🦆 🦆

New blog post: DuckDB Table Functions in Java 🦆☕ In a large organization, data is spread across many systems, including relational databases, document stores, message queues, data lakes, and cloud data warehouses. The layer that ties these together is often a JVM-based distributed query engine. Teams increasingly add #DuckDB# to these Java environments for fast single-node analytics. The DuckDB #Java# client can register table functions written in pure Java, exposing any Java-accessible data source as a SQL table. That turns @duckdb into a single-node query engine for heterogeneous joins across remote systems and local files, with no export step. Dive into the rest:

Ducklake with duckdb is really really good. Tell your agent to use it if you ask it to import a lot of data ( like health data from Fitbit ). If you use Hermes, just go “/learn duckdb and ducklake and use it” and all your data asks will get better.

🦆🤓 When Denis Hirn implemented DuckDB’s first recursive CTE operator in 2020, correctness determined the design: evaluate the non-recursive term once, then evaluate the recursive term until the next working table is empty. That established the right semantic contract, but reusable runtime state was scoped too narrowly. In the upcoming DuckDB v2.0 release, we assign those scopes explicitly. #DuckDB’s# recursive CTE engine now treats recursion as one long-lived computation: it retains eligible epoch-invariant state, chooses execution modes from exact frontier cardinalities and physical work, probes keyed state directly and gives `USING KEY ... UNION` changed-key semantics. Read more in this preview of the forthcoming v2.0 release: