modern-sql.com now covers DuckDB.

Today's Cloudflare outage has affected the DuckDB documentation site. While it seems to be mostly recovered now, it will take some time until everything stabilizes. If you need to look things up in the DuckDB documentation now, feel free to use our PDF: duckdb.github.io/duckdb-docs-...

We took Canada’s Spatial Access Measures dataset (big, clunky CSVs) → turned it into a single GeoParquet file. Add DuckDB-WASM + deck.gl & you get - instant queries - smooth maps - no backend Public data, but actually usable. developmentseed.org/blog/2025-10... @saadiqmohiuddin.bsky.social

I just launched github.com/tobilg/sql-w... It's a tiny (<10kb gzipped) wrapper around @duckdb.org WASM that can run queries interactively, and be embedded in plain HTML websites, as well as all other mayor frontend frameworks... It's an early version, feedback warmly appreciated!

📣 New blog post by @dtenwolde.bsky.social. 🕸️ In this post, we show how to use DuckDB and the DuckPGQ community extension to analyze financial data for fraudulent patterns with the SQL/PGQ graph syntax that's part of SQL:2023. 📖 Visit duckdb.org/2025/10/22/d... to read the post.

In a new guest blog post, Mark Harrison (Madhive) presents Frozen DuckLakes. These are read-only DuckLakes that only require object storage and are frozen in time. He shows a process for creating and freezing DuckLakes, and demonstrates their use and performance. 📖 ducklake.select/2025/10/24/f...

Created a DNS extension for @duckdb.org today: github.com/tobilg/duckd... Hopefully it will be available via the Community Extensions soon!

Huey 1.0.10 is now released: github.com/rpbouman/hue... demo: rpbouman.github.io/huey/src/ind... - DuckDB version upgrade (1.4.0) - Support for translation files. Currently supported: English, Dutch and Brazilian Portuguese (thanks @nosklo!) - bugfixes and UI improvements

Had a blast speaking about query.farm at the #DuckDB Amsterdam Meetup #3 where I had time to spend some time with my heroes @carlo.piovesan.io @samansmink.bsky.social @szarnyasg.org Tania Bogatsch and so many more awesome people! Thank You @duckdb.org for giving space to the community! #opensource

We just launched the “DuckDB in Science” site, a curated collection of papers, lectures and podcasts about DuckDB in research: duckdb.org/science/ 🎡 If you would like to learn more about DuckDB in Science, consider joining our meetup in London this Thursday: www.meetup.com/duckdb/event...

🎓 On September 4, we are hosting a new kind of meetup in London which will focus on the use of DuckDB in Science and Education! ⚡️ We still have some spots for lightning talks. If you're working with DuckDB in your research and/or classroom, consider sharing your story! 🔗 duckdb.org/events/2025/...

We just published a deep dive on spatial joins in DuckDB by @maxxen.bsky.social. In this blog post, Max explains how spatial joins evolved in DuckDB and how the current operator harnesses R-Trees. Read the full post at duckdb.org/2025/08/08/s...

Is anyone aware whether it’s possible to set CORS policies on the R2 (@cloudflare.social) Iceberg REST catalog?

Weekend project, using R2 + DuckDB wasm to build a low price frontend for big data analytics crimede-coder.com/graphs/GSUBo...

Quack!!

Beyond excited to share that I'm now working with DuckDB Labs! My first priority will be the DuckDB Rust client, which will receive a lot more love going forward. 🎉 🦆 ❤️

My #PyConUS talk is up! Tame data science file zoos with @duckdb.org! Read files of many shapes from any cloud, including your messiest CSVs. Then, organize all of your input tables, output tables, views, and relationships in one DuckDB file. No final_v3.csv! youtu.be/Yq-hxgysWLQ?...

Yesterday DuckDB Labs announced DuckLake, a new Open data and catalog format. Here is a bit about why it is so awesome, how it solves some key problems with existing technologies, and why we're excited to host it in the cloud at MotherDuck.

Ducklake is a really elegant solution to the data lake. Radically simple and completely open.

And the biggest winner is... DuckDB support for running queries on [remote] parquet files. This happens to be a basic building block of DuckLake and a few other alternative lake technologies

Today we're launching DuckLake, an integrated data lake and catalog format powered by SQL. DuckLake unlocks next-generation data warehousing where compute is local, consistency central, and storage scales till infinity. ⁠ducklake is an open standard and we implemented it in the "ducklake" extension.

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

New post by Pedro Holanda, Ian Cook, Dewey Dunnington and Bryce Mecum: Arrow IPC Support in DuckDB This blog post introduces the new arrow community extension, which boosts interoperability by allowing to consume/produce data through the Arrow IPC Serialization Format. duckdb.org/2025/05/23/a...

DuckDB v1.3.0 “Ossivalis” is out and it packs a ton of new features, fixes and optimizations. See the announcement blog post: duckdb.org/2025/05/21/a...

A new preprint from database researchers found DuckDB the most environmentally efficient system: arxiv.org/pdf/2504.18980

So thrilled to announce we've released Instant SQL in both the MotherDuck and DuckDB UIs! It's a new interaction pattern for writing SQL queries that provides realtime result previews and deep query inspection & debugging. Bye bye run button 👋 Truly, literally only possible with DuckDB

📢 The fifth and final episode of the “DuckDB in Research” podcast series is out! Haralampos Gavriilidis | SheetReader: Efficient spreadsheet parsing 🎧 Apple: podcasts.apple.com/us/podcast/h... 🎧 Spotify: open.spotify.com/episode/2CRR...

How do you detect if a subprocess errors? You might rely on error codes, great. And to be extra friendly you might also look for the substring `error` in the stdout stream, just to be sure. Welcome to MSBuild's take on error handling, and also my day. PR to @duckdb at github.com/duckdb/duckd...

I created a small DuckDB extension to choose file interactively using native file open dialogs. Now you can install this via Community Extensions repository! github.com/yutannihilat...

New sticker! @wasm.io has been great, see you all next year!

@ospencer.dev on webassembly GC as compiler target was pretty great, #wasmio

Super dense (and cool) from @lukewagner.name (from @fastly.com) on colorless async + threading. Thanks a lot, need to get the slides

Getting started at #wasmio

Excited to share my OS research at #wasmio25 in just 2 days! Be sure to stop by it will be great! 2025.wasm.io/sessions/sma...

New blog post by Sam Ansmink: Maximizing Your Delta Scan Performance In this post, Sam puts the DuckDB delta extension through its paces with some benchmarks and take a deep dive into some of the new performance-related features. Read more at duckdb.org/2025/03/21/m...

New blog: Why DuckDB is my first choice for data processing: www.robinlinacre.com/recommend_du...

New blog post by @a13x.bsky.social and @archie.sarrewood.com: Reading and Writing Google Sheets in DuckDB This post introduces the gsheets community extension, which enables DuckDB to directly read from and write to Google Sheets. duckdb.org/2025/02/26/g...

Are you working with geospatial data, or have you been wondering why we even use it? Then, this article might be for you. Introducing & showcasing its ubiquitous use. Exploring DuckDB's spatial capabilities, transforming complex geographic analysis into simple SQL queries. Hacking on Foursquare.

New blog post by @hannes.muehleisen.org: Prefix Aliases in SQL In DuckDB v1.2.0, you can use prefix aliases in the SELECT, FROM and JOIN clauses to make queries more readable. To learn more, visit duckdb.org/2025/02/25/p...

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/

DuckDB's Time Lord, Richard Wesley is on a roll. He just published his third blog post in a week*, describing how AsOf joins are planned by DuckDB. Read more at duckdb.org/2025/02/19/a... *Maybe some time travel is involved?

I'm starting a DuckDB newsletter, feel free to subscribe at learningduckdb.com

@blef.fr presented github.com/Bl3f/yato at DuckCon, and yesterday I've seen a talk by chrislaffra.com on PySheets at a DuckDB meetup. Now wondering how to put those ideas together for an in-browser SQL orchestrator. Even just precomputing dependencies offline and do computations on the fly.

This week, we are publishing two blog posts about window functions from our group-by therapist, Richard Wesley. The first post describes new window function features in DuckDB, including GROUPS framing and aggregate/function modifiers. Read more at duckdb.org/2025/02/10/w...

We're testing a new DuckDB install experience for Linux and MacOS: curl install.duckdb.org | bash Happy to hear feedback!

🚀 Today at #DuckCon, I’ll give a lightning talk on graph analytics in @duckdb.org using SQL/PGQ & the DuckPGQ extension! In just 5 mins, get up to speed on the new syntax & running graph queries inside DuckDB. 🎥 Live stream (3 PM CET): www.youtube.com/@duckdb 📅 Program: duckdb.org/events/2025/...

DuckCon #6 a few hours away, Pakhuis De Zwijger or live on the @duckdb.org Youtube channel. duckdb.org/events/2025/... Speaker are impressive, looking forward to hear from them, chance to see in person a bunch of GitHub/Discord handles / talk DuckDB a bunch. I will be around, come to say quack!

My @ldbcouncil.org TUC talk is online! 🎥 Learn about #DuckPGQ and #SQL/#PGQ here: 👉 www.youtube.com/watch?v=Fzci... Catch me at @fosdem.bsky.social on Feb 1 in the Data Analytics room, where I’ll continue spreading the word about #DuckPGQ and #SQL/#PGQ. Hope to see you there! 🚀 #FOSDEM2025

We are proud to announce that DuckDB's co-creator, Prof. Dr. Hannes Mühleisen, received the Dutch Prize for ICT Research 2025. This prize is awarded each year to a computer scientist in the Netherlands, who has conducted particularly innovative research within 15 years of obtaining their doctorate.