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.
🚀 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...
🔎 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...
November 12, 2025 at 1:22 PM
🚀 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...
🔎 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...
➗ 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...
November 6, 2025 at 12:52 PM
📢 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...
➗ 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...
📢 A new DuckDB in Research podcast episode is out.
📈 In this week's episode, Jack Waudby interviews Mihail Stoian (@mihailstoian.bsky.social), PhD student at the Data Systems Lab, UT Nuremberg about the Parachute approach for robust query processing.
🎧 Listen at duckdb.org/science/miha...
📈 In this week's episode, Jack Waudby interviews Mihail Stoian (@mihailstoian.bsky.social), PhD student at the Data Systems Lab, UT Nuremberg about the Parachute approach for robust query processing.
🎧 Listen at duckdb.org/science/miha...
October 30, 2025 at 10:04 AM
📢 A new DuckDB in Research podcast episode is out.
📈 In this week's episode, Jack Waudby interviews Mihail Stoian (@mihailstoian.bsky.social), PhD student at the Data Systems Lab, UT Nuremberg about the Parachute approach for robust query processing.
🎧 Listen at duckdb.org/science/miha...
📈 In this week's episode, Jack Waudby interviews Mihail Stoian (@mihailstoian.bsky.social), 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, @hannes.muehleisen.org 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 today's blog post, @hannes.muehleisen.org 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.
October 27, 2025 at 3:43 PM
🎞️ 𝘊𝘢𝘯 you store a movie in DuckDB?
In today's blog post, @hannes.muehleisen.org 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 today's blog post, @hannes.muehleisen.org 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...
📖 ducklake.select/2025/10/24/f...
October 24, 2025 at 6:38 PM
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...
📖 ducklake.select/2025/10/24/f...
There's a new DuckDB episode from @disseminatepodcast.bsky.social.
In S02E02, host Jack Waudby interviews Abigale Kim (@abigalekim.bsky.social), a PhD student at the University of Wisconsin-Madison on anarchy in database extensions.
🎧 Listen to the full episode at duckdb.org/science/abig...
In S02E02, host Jack Waudby interviews Abigale Kim (@abigalekim.bsky.social), a PhD student at the University of Wisconsin-Madison on anarchy in database extensions.
🎧 Listen to the full episode at duckdb.org/science/abig...
October 23, 2025 at 12:21 PM
There's a new DuckDB episode from @disseminatepodcast.bsky.social.
In S02E02, host Jack Waudby interviews Abigale Kim (@abigalekim.bsky.social), a PhD student at the University of Wisconsin-Madison on anarchy in database extensions.
🎧 Listen to the full episode at duckdb.org/science/abig...
In S02E02, host Jack Waudby interviews Abigale Kim (@abigalekim.bsky.social), 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 @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 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.
October 22, 2025 at 7:23 PM
📣 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 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.
🇫🇮 We are hosting a pub session next week during the @helsinkidataweek.bsky.social, where you can chat with DuckDB's co-creator, @hannes.muehleisen.org and have a drink with members of the DuckDB community.
🎟️ Sign up on Luma: luma.com/s5sl9qxx
🎟️ Sign up on Luma: luma.com/s5sl9qxx
October 20, 2025 at 2:29 PM
🇫🇮 We are hosting a pub session next week during the @helsinkidataweek.bsky.social, where you can chat with DuckDB's co-creator, @hannes.muehleisen.org and have a drink with members of the DuckDB community.
🎟️ Sign up on Luma: luma.com/s5sl9qxx
🎟️ 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 (@teggy.org). 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 S02E01, host Jack Waudby interviews Torsten Grust (@teggy.org). 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!
October 17, 2025 at 2:45 PM
The “DuckDB in Science” edition of the Disseminate podcast is back for a second season!
In S02E01, host Jack Waudby interviews Torsten Grust (@teggy.org). 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 S02E01, host Jack Waudby interviews Torsten Grust (@teggy.org). 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!
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.
🗂️ Administratively:
– The project is now maintained by the core DuckDB team as a primary DuckDB client.
– The license of the driver stays the same.
October 16, 2025 at 1:19 PM
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.
🗂️ Administratively:
– The project is now maintained by the core DuckDB team as a primary DuckDB client.
– The license of the driver stays the same.
✨ 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.
🚀 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.
October 1, 2025 at 12:22 PM
✨ 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.
🚀 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.
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 ⚡
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 ⚡
September 29, 2025 at 2:13 PM
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 ⚡
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 ⚡
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!
September 23, 2025 at 2:53 PM
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!
🚀 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...
Check the announcement blog for more details ducklake.select/2025/09/17/d...
September 18, 2025 at 9:20 AM
🚀 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...
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...
For more details, read the announcement blog post at
duckdb.org/2025/09/16/a...
September 16, 2025 at 11:55 AM
📈 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...
For more details, read the announcement blog post at
duckdb.org/2025/09/16/a...
$ duckdb
D .mode line
D SELECT stargazers_count FROM read_json('https://api.github.com/repos/duckdb/duckdb');
stargazers_count = 32768
In other words:
D .mode line
D SELECT stargazers_count FROM read_json('https://api.github.com/repos/duckdb/duckdb');
stargazers_count = 32768
In other words:
September 14, 2025 at 11:22 AM
$ duckdb
D .mode line
D SELECT stargazers_count FROM read_json('https://api.github.com/repos/duckdb/duckdb');
stargazers_count = 32768
In other words:
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 holding the DuckDB Amsterdam Meetup next week, featuring talks by @rolandbouman.bsky.social, Tania Bogatsch and @qxip.bsky.social:
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.
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.
September 10, 2025 at 1:41 PM
We are holding the DuckDB Amsterdam Meetup next week, featuring talks by @rolandbouman.bsky.social, Tania Bogatsch and @qxip.bsky.social:
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.
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.
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 would like to learn more about DuckDB in Science, consider joining our meetup in London this Thursday: www.meetup.com/duckdb/event...
September 2, 2025 at 4:59 PM
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 would like to learn more about DuckDB in Science, consider joining our meetup in London this Thursday: www.meetup.com/duckdb/event...
🔬 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/...
🔍 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/...
August 28, 2025 at 10:03 PM
🔬 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/...
🔍 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.
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.
August 20, 2025 at 1:54 PM
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.
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.
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...
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...
August 8, 2025 at 3:24 PM
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...
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...
🎨 DuckDB's logo is now part of the Devicon collection.
July 24, 2025 at 5:27 PM
🎨 DuckDB's logo is now part of the Devicon collection.
🚀 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 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...
July 8, 2025 at 11:02 AM
🚀 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 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...
📢 DuckLake 0.2 is out! We added new features to the specification and improved support in the DuckDB ducklake extension.
See the announcement blog post at duckdb.org/2025/07/04/d....
See the announcement blog post at duckdb.org/2025/07/04/d....
July 4, 2025 at 3:03 PM
📢 DuckLake 0.2 is out! We added new features to the specification and improved support in the DuckDB ducklake extension.
See the announcement blog post at duckdb.org/2025/07/04/d....
See the announcement blog post at duckdb.org/2025/07/04/d....
The DuckDB v1.3.1 bugfix release is out:
github.com/duckdb/duckd...
As usual, the CLI, Python, C and C++ clients are already available. We will roll out the other clients over the coming days.
github.com/duckdb/duckd...
As usual, the CLI, Python, C and C++ clients are already available. We will roll out the other clients over the coming days.
June 16, 2025 at 2:04 PM
The DuckDB v1.3.1 bugfix release is out:
github.com/duckdb/duckd...
As usual, the CLI, Python, C and C++ clients are already available. We will roll out the other clients over the coming days.
github.com/duckdb/duckd...
As usual, the CLI, Python, C and C++ clients are already available. We will roll out the other clients over the coming days.