DuckDB

1,016 posts
Opens profile photo
DuckDB
@duckdb
DuckDB is an analytical in-process SQL database management system. "DuckDB" and the DuckDB logo are registered trademarks of the DuckDB Foundation.
Amsterdam, The Netherlandsduckdb.org

DuckDB’s posts

We are proud to release the first major version of DuckDB, v1.0.0, codenamed "Snow Duck". This version is a culmination of almost six years of research and development. Today we are shipping an innovative database system with a backwards-compatible storage format. Check out our
Image
We released DuckDB 1.0.0 a little over a year ago with a small easter egg. Since then, no one reported finding it, so we're revealing it: the hash of the DuckDB 1.0.0 binary starts with the duck emoji: 0x1f986 = 🦆.
Image
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've implemented it in
Image
Fun fact: DuckDB is faster at counting the lines of a CSV file than the UNIX word count command – and it also parses the file to identify its dialect (separator, quote character, etc.). Here are the timings for a 3 GB CSV file: 2.966 seconds for `wc -l` and 1.261 seconds for
Image
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 in CS within 15 years of
Since the release of DuckDB v1.0.0 last summer, the time needed to run all TPC-H queries on the 300 GB data set went from 5 minutes to less than 2 minutes! These experiments were run on a MacBook Pro (M1 Max / 64 GB RAM) with the Hyperfine benchmark tool to reduce noise.
Image
Did you know that Google Colab has DuckDB as a preinstalled package since mid-2023? It also receives regular upgrades and is now on version 1.1.0.
Image
We strive to ensure that the DuckDB project stays open-source in the long term. That's why we set up the DuckDB Foundation, an Amsterdam-based non-profit organization, in 2021. The Foundation owns the intellectual property of the DuckDB project and enshrines the availability of
We started a series of blog posts called “DuckDB tricks”. In these posts, we will present some useful shorthands, hacks, and design patterns for DuckDB. In the first part of the series, explains some techniques for handling floats, fine-tuning the CSV reader, and
Image
The latest DuckDB book, published by O'Reilly, is available in print. We ordered our copy and received it today. Thanks to Wei-Meng Lee for his educating readers on how to use DuckDB!
Image