DuckDB
@duckdb.org
DuckDB is an analytical in-process SQL database management system. "DuckDB" and the DuckDB logo are registered trademarks of the DuckDB Foundation.
In seven weeks, we will host the first DuckDB Developer Meeting in Amsterdam. We have four exciting talks lined up on building extensions in DuckDB, encryption in DuckDB, DuckPL and GizmoEdge. For more details and the registration links, please head to duckdb.org/events/2026/...
DuckLake now supports data inlining with PostgreSQL and SQLite catalogs! You can avoid the small files problem in your lakehouse with any DuckLake supported catalog. Update your DuckLake extension in any client on DuckDB 1.4.x to use this feature. P.S. Don't forget to flush!
We are happy to announce DuckDB v1.4.3 LTS, our latest patch release. Along with bugfixes, this release ships native extensions and Python support for Windows ARM64. Head to duckdb.org/2025/12/09/a... for the announcement blog post and installation instructions.
We are hosting the DuckDB Developer Meeting on January 30 (Friday) in Amsterdam, the day before the FOSDEM weekend in Brussels. This is a new kind of event focused on development in DuckDB and with DuckDB. Check out the preliminary programme and register at duckdb.org/events/2026/...
In DuckDB v1.4.2, we shipped a number of features and improvements to the DuckDB-Iceberg extension: insert, update, and delete statements are all supported now. Read Tom Ebergen's new article on these features at duckdb.org/2025/11/28/i...
DuckDB v1.4 introduced the much-requested feature of database encryption. In our new blog post, and explain how the encryption works under the hood: duckdb.org/2025/11/19/e...
DuckDB's website and extension installation endpoint are still intermittently down due to today's Cloudflare outage – see our status page for more details: status.duckdb.org For a single-file PDF copy of our documentation, see our recent post.
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 released DuckDB v1.4.2, the second patch release of our LTS edition. 🔎 We are shipping new Iceberg features, improved logger/profiler integration and several bugfixes. The new DuckDB version can also read and write Vortex files. 📖 For more details, read duckdb.org/2025/11/12/a...
📢 The final episode of DuckDB in Research's second season is out! ➗ This week, host Jack Waudby interviews Paul Groß, PhD student at CWI Amsterdam, to explore his work on adaptive factorization and worst-case optimal joins. 🎧 Listen to the episode at duckdb.org/science/paul...
🚀 DuckDB Labs is hiring a DevOps Engineer and a Sales Engineer in Amsterdam 🇳🇱 🤔 Want to join one of the fastest-growing database startups? Work with the team that disrupted analytical data management and grow with us in your new role. 👉 Apply now until November 7: duckdblabs.com#jobs%EF%BF%BC
📢 A new DuckDB in Research podcast episode is out. 📈 In this week's episode, Jack Waudby interviews Mihail Stoian (), PhD student at the Data Systems Lab, UT Nuremberg about the Parachute approach for robust query processing. 🎧 Listen at duckdb.org/science/miha...
🎞️ 𝘊𝘢𝘯 you store a movie in DuckDB? In today's blog post, shows how to store a movie as a table encoding the RGB codes pixel-by-pixel, and how to process it: duckdb.org/2025/10/27/m... Now, whether you 𝘴𝘩𝘰𝘶𝘭𝘥 store a movie in DuckDB... we'll leave that to your judgment.
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...
We recently revamped our installation page to make it sleeker but this also meant removing the nightly builds. While there's less need for nightly builds now – 99% of users should use the latest stable – they can still be useful for testing, so we created a page for them: duckdb.org/install/prev...
There's a new DuckDB episode from . In S02E02, host Jack Waudby interviews Abigale Kim (), a PhD student at the University of Wisconsin-Madison on anarchy in database extensions. 🎧 Listen to the full episode at duckdb.org/science/abig...
📣 New blog post by . 🕸️ 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.
DuckDB Labs is looking for a Customer Support Engineer to help customers set up and operate DuckDB. As Customer Support Engineer, you'll operate in the intersection of the DuckDB community, the DuckDB Labs customers, and the DuckDB core development team. Apply at duckdblabs.com/jobs/custome...
🇫🇮 ​We are hosting a pub session next week during the , where you can chat with DuckDB's co-creator, and have a drink with members of the DuckDB community. 🎟️ Sign up on Luma: luma.com/s5sl9qxx
The “DuckDB in Science” edition of the Disseminate podcast is back for a second season! In S02E01, host Jack Waudby interviews Torsten Grust (). Torsten is a professor at the University of Tübingen and has been using DuckDB for 5+ years – for teaching, research and Advent of Code puzzles!
In this episode, he shared his insights about recursive CTEs, trampoline queries and teaching databases with DuckDB. 🎧 You can listen the podcast on all major platforms: – Apple – podcasts.apple.com/us/podcast/r... – Spotify – open.spotify.com/episode/3Mdb... – YouTube – youtu.be/Hoo0KZ6EDq0
We migrated the DuckDB Go driver's repository from marcboeker/go-duckdb to github.com/duckdb/duckd.... What does this mean in practice? 🗂️ Administratively: – The project is now maintained by the core DuckDB team as a primary DuckDB client. – The license of the driver stays the same.
🛠️ Operationally: – In new projects, you can install the Go driver as follows: go get github.com/duckdb/duckdb-go/v2 – If your projects are already using the Go driver, please consult the migration guide in the new repository's README: github.com/duckdb/duckd...
🏆 We'd like to thank Marc Boeker for all his work on creating this driver! We are looking forward to working with the community on the DuckDB Go driver.
🚀 We released DuckDB v1.4.1, the first bugfix release of our LTS edition. 🔎 We expect LTS users to be particularly curious about changes in the system, so we wrote up a short blog post highlighting the most important fixes and improvements. duckdb.org/2025/10/07/a...
✨ We launched a new installation page for DuckDB! 🚀 The new page lets you install the latest stable DuckDB release with just one or two clicks. If the defaults don't fit your use case, no worries: alternative download methods remain available for many clients.
🌃 Nightly (preview) builds are still published on GitHub, but we are no longer recommending them for general use. They should only be used when troubleshooting issues or testing pre-release features.
Are you streaming into your Lakehouse? Traditional formats suffered with the “many small files” problem — OLAP engines merge them reactively with long jobs. ⏳ DuckLake takes a proactive path: Data Inlining + async flush to parquet while always keeping data queryable ⚡
We published a new deep dive by Laurens Kuiper, who recently redesigned DuckDB's sort. One data point: ordering the TPC-H SF100 lineitem table with the memory limit set to 30 GB is 3× faster in DuckDB v1.4 than in v1.3. Read more at duckdb.org/2025/09/24/s...
“Open source is giving back, because it means everyone who supports our work can participate and benefit from the software we are making." — () at Open Lakehouse + AI Amsterdam 🇳🇱 Ready to shape the future of data, open source, and AI together? ⬇️
An error occurred while loading the video. Please try again.
Our website, duckdb.org, has recently crossed 4 million monthly unique visitors. It now handles 110M+ requests and serves more than one petabyte of data each month!
🚀 Kotlin DataFrame 1.0.0-Beta3 is here! Working with data in Kotlin is now smoother thanks to Parquet and DuckDB support, improved compile-time schema tracking via the Compiler Plugin, and refreshed docs. Read the full release notes 👇 kotl.in/w2eq2c
🚀 We released version 0.3 of the DuckLake specification and the DuckDB ducklake extension today. It includes interoperability with Iceberg, support for geometry types and more. Check the announcement blog for more details ducklake.select/2025/09/17/d...
📈 DuckDB 1.4.0 is out! This is our first LTS release which comes with *one year of community support*. It also supports database encryption, the MERGE SQL statement and Iceberg writes. For more details, read the announcement blog post at duckdb.org/2025/09/16/a...
We're testing a new distribution channel for : images. For now they live at `hfmuehleisen/duckdb`, feel free to test them out. And yes, hell got a little colder today. hub.docker.com/r/hfmuehleis...
$ duckdb D .mode line D SELECT stargazers_count FROM read_json('https://api.github.com/repos/duckdb/duckdb'); stargazers_count = 32768 In other words:
We are beta testing a new, more streamlined installation site at duckdb.org/install. Let us know what you think!
Nederlandse Spoorwegen (NS) has been hosting a weekly puzzle where you have to guess the name of a train station for an anagram. We already use the Dutch railway dataset in our demos, so writing a SQL solver for this puzzle was an interesting exercise. Read more at duckdb.org/2025/09/11/s...
We are holding the DuckDB Amsterdam Meetup next week, featuring talks by , Tania Bogatsch and : www.meetup.com/duckdb/event... The event is already at capacity but consider joining the wait list because there are always last-minute RSVP cancellations.
In the recent npm supply chain attack, DuckDB's Node.js and Wasm packages were compromised with malware. We have investigated the issue, deprecated the affected packages and released new versions. We have released a security advisory that contains our full postmortem: github.com/duckdb/duckd...
Big Data on the Move: Can a Framework Laptop 13 ultrabook run terabyte-sized workloads with DuckDB? ran the experiments and shared his finding in our latest blog post: duckdb.org/2025/09/08/d...
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...
📩 If you are an author of a paper using DuckDB, please submit your work following the guidelines at the bottom of the page.
🔬 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/...
New blog post by Petrica Leuca: Basic Feature Engineering with DuckDB In this post, we show how to perform essential machine learning data preprocessing tasks—like missing value imputation, categorical encoding, and feature scaling—directly in DuckDB using SQL and benchmark it against scikit-learn.
🎓 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 . 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...
Thanks for pointing this out. We added this to our list of Friendly SQL Features: github.com/duckdb/duckd...
Does @duckdb.org actually support percentual limits? I just used LIMIT 10% as a joke and it just worked. Mindblown! 🤯 These are the small details that I love! 💛
🎨 DuckDB's logo is now part of the Devicon collection.
All primary clients (including Node.js, Go, Java, Rust, etc.) have been upgraded to DuckDB v1.3.2.
🚀 The DuckDB 1.3.2 bugfix release is out! 📦 The Python and CLI clients are already on the latest version, while the rest will follow in the coming days. 🔖 See the detailed change log at github.com/duckdb/duckd...
🚀 The DuckDB 1.3.2 bugfix release is out! 📦 The Python and CLI clients are already on the latest version, while the rest will follow in the coming days. 🔖 See the detailed change log at github.com/duckdb/duckd...