DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser

Hacker News Top Tools

Summary

DuckDB 1.5.2 adds production-ready DuckLake v1.0 lakehouse format, Iceberg extension improvements, Jepsen testing, and a revamped browser shell with file storage.

No content available
Original Article
View Cached Full Text

Cached at: 04/22/26, 03:22 PM

# Announcing DuckDB 1.5.2 Source: [https://duckdb.org/2026/04/13/announcing-duckdb-152](https://duckdb.org/2026/04/13/announcing-duckdb-152) *TL;DR: We are releasing DuckDB version v1\.5\.2, a patch release with bugfixes and performance improvements, and support for the DuckLake v1\.0 lakehouse format\.* In this blog post, we highlight a few important fixes in DuckDB v1\.5\.2, the second patch release in[DuckDB's v1\.5 line](https://duckdb.org/2026/03/09/announcing-duckdb-150.html)\. You can find the complete[release notes on GitHub](https://github.com/duckdb/duckdb/releases/tag/v1.5.2)\. To install the new version, please visit the[installation page](https://duckdb.org/install/)\. ## [Data Lake and Lakehouse Formats](https://duckdb.org/2026/04/13/announcing-duckdb-152#data-lake-and-lakehouse-formats) ### [DuckLake](https://duckdb.org/2026/04/13/announcing-duckdb-152#ducklake) We are proud to release a stable, production\-ready lakehouse specification and its reference implementation in DuckDB\. We published a[detailed blog post on the DuckLake site](https://ducklake.select/2026/04/13/ducklake-10/)but here's a quick summary: DuckLake v1\.0 ships dozens of bugfixes and guarantees backward\-compatibility\. Additionally, it has a number of cool features:[data inlining](https://ducklake.select/2026/04/02/data-inlining-in-ducklake/), sorted tables, bucket partitioning, and deletion buffers as Iceberg\-compatible Puffin files\. More on this in the[announcement blog post](https://ducklake.select/2026/04/13/ducklake-10/)\. ### [Iceberg](https://duckdb.org/2026/04/13/announcing-duckdb-152#iceberg) The[Iceberg extension](https://duckdb.org/docs/current/core_extensions/iceberg/overview.html)ships a number of new features\. It now supports the following: - `GEOMETRY`type - `ALTER TABLE`statement - Updates and deletes from[partitioned tables](https://iceberg.apache.org/docs/latest/partitioning/) - Truncate and bucket partitions Last week, DuckDB Labs engineer Tom Ebergen gave a talk at the[Iceberg Summit](https://www.icebergsummit.org/)titled[“Building DuckDB\-Iceberg: Exploring the Iceberg Ecosystem”](https://duckdb.org/library/building-duckdb-iceberg-exploring-the-iceberg-ecosystem/), where he shared his experiences with Iceberg\. ## [Preliminary Jepsen Test Results](https://duckdb.org/2026/04/13/announcing-duckdb-152#preliminary-jepsen-test-results) To make DuckDB as robust as possible, we started a collaboration with[Jepsen](https://jepsen.io/)\. The preliminary test suite is available at[https://github\.com/duckdb/duckdb\-jepsen](https://github.com/duckdb/duckdb-jepsen)\. The test suite has uncovered a bug that was triggered by`INSERT INTO`statements that perform conflict resolution on a primary key, and already[shipped a fix](https://github.com/duckdb/duckdb/pull/21489)in this release\. ## [New Online Shell](https://duckdb.org/2026/04/13/announcing-duckdb-152#new-online-shell) The online[WebAssembly](https://duckdb.org/docs/current/clients/wasm/overview.html)shell at[`shell\.duckdb\.org`](https://shell.duckdb.org/)received a complete overhaul\. A highlight of the new shell is the ability to store and list files using the`\.files`dot command and its variants\. Using the file storage feature, you can turn your browser session into workbench: you can drag\-and\-drop files from your local file system to upload them, create new ones using DuckDB's[`COPY \.\.\. TO`statement](https://duckdb.org/docs/current/sql/statements/copy.html#copy--to)and download the results\. For more information on this feature, use the`\.help`command\. ![Example use of the new online shell at shell.duckdb.org](https://duckdb.org/images/blog/online-shell-example.png) The new shell comes with a few built\-in datasets: you're welcome to try them out and experiment\. Your old links to`shell\.duckdb\.org`should still work but if you experience any problems, please submit an issue in the[`duckdb\-web`repository](https://github.com/duckdb/duckdb-wasm)\. ## [Benchmarks](https://duckdb.org/2026/04/13/announcing-duckdb-152#benchmarks) We benchmarked DuckDB using the Linux v7 kernel on an[r8gd\.8xlarge](https://instances.vantage.sh/aws/ec2/r8gd.8xlarge?currency=USD)instance with 32 vCPUs, 256 GiB RAM, and an NVMe SSD\. We first ran the scale factor 300 test on Ubuntu 24\.04 LTS, then upgraded to Ubuntu 26\.04 beta\. We noticed that the composite TPC\-H score shows a**~10% improvement**, jumping from 778,041 to 854,676 when measured with TPC\-H's QphH@Score metric\. ## [Coming Up](https://duckdb.org/2026/04/13/announcing-duckdb-152#coming-up) This quarter, we have quite a few exciting events lined up\. **DuckCon \#7\.**On June 24, we'll host our next user conference,[DuckCon \#7](https://duckdb.org/events/2026/06/24/duckcon7/), in Amsterdam's beautiful[Royal Tropical Institute](https://www.kit.nl/about-us/)\. If you have been building cool things with DuckDB, consider submitting a talk by April 22\. Registrations are also open – and free\! **AI Council Talk\.**On May 12, DuckDB co\-creator Hannes Mühleisen will give a talk at AI Council 2026 titled[“Super\-Secret Next Big Thing for DuckDB”](https://duckdb.org/library/super-secret-next-big-thing-for-duckdb/)\. Well, at this point, we cannot tell you more than he will present the super\-secret next big thing for DuckDB\. But, if you cannot make it, don't worry: we'll publish the presentation afterwards\. **Ubuntu Summit Talk\.**We already talked about performance on Ubuntu\. In late May, Gábor Szárnyas of DuckDB Labs will give a talk titled[“DuckDB: Not Quack Science”](https://duckdb.org/library/duckdb-not-quack-science/)at the[Ubuntu Summit](https://ubuntu.com/summit)\. ## [Conclusion](https://duckdb.org/2026/04/13/announcing-duckdb-152#conclusion) This post is a short summary of the changes in v1\.5\.2\. As usual, you can find the[full release notes on GitHub](https://github.com/duckdb/duckdb/releases/tag/v1.5.2)\.

Similar Articles

DuckDB: it's not quack science

Lobsters Hottest

DuckDB is an open-source embedded analytical database that supports direct querying of files, embedding into applications, and provides friendly SQL extensions. It is more efficient than traditional Unix pipes in data analysis scenarios.

Quack: The DuckDB Client-Server Protocol

Hacker News Top

DuckDB introduces 'Quack', a new client-server protocol that enables DuckDB instances to communicate via HTTP, supporting concurrent writers and remote access while maintaining simplicity and performance.

Statistics that live in your SQL

Hacker News Top

the-stats-duck v0.6.0 is an open-source DuckDB extension that brings statistical analysis and plotting directly into SQL, including regression, bootstrapping, and ggplot-like visualization.

datasette 1.0a31

Simon Willison's Blog

Datasette 1.0a31 introduces the ability to execute write queries and save stored queries (renamed from canned queries) for users with appropriate permissions, enhancing data editing capabilities.

datasette 1.0a28

Simon Willison's Blog

Datasette 1.0a28 alpha release fixes compatibility bugs and resource management issues discovered in the previous alpha, including fixes for execute_write_fn() callbacks, database cleanup methods, and a new pytest plugin for automatic cleanup in tests.