<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/sources/duckdb/best-of/2025" -->

---
title: Best DuckDB posts of 2025 | daily.dev
description: The most upvoted DuckDB posts of 2025, curated by the daily.dev community.
canonical: https://daily.dev/sources/duckdb/best-of/2025
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:url: https://daily.dev/sources/duckdb/best-of/2025
og:type: website
og:site_name: daily.dev
og:title: Best DuckDB posts of 2025 | daily.dev
og:description: The most upvoted DuckDB posts of 2025, curated by the daily.dev community.
og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph
---

# Best of DuckDB — 2025

1. 1  
[](/posts/the-duckdb-local-ui-yiozhryai "The DuckDB Local UI")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
5m read time • Mar 12, 2025  
### The DuckDB Local UI  
DuckDB, in collaboration with MotherDuck, has introduced a built-in local UI available starting from DuckDB v1.2.1\. This UI can be launched via terminal or a SQL command and offers features such as interactive notebooks, a column explorer, and detailed table summaries. It runs all queries locally, ensuring data privacy unless explicitly connected to MotherDuck. The UI is designed to be simple, fast, feature-rich, and fully open source.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/e3a7b35e2b25f47b119fe54969197aec?_a=AQAEuj9)  
133  
7
2. 2  
[](/posts/ducklake-0-2-jqqfxk39j "DuckLake 0.2")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
6m read time • Jul 04, 2025  
### DuckLake 0.2  
DuckLake 0.2 introduces significant improvements including secrets management for credentials, enhanced Parquet file settings, relative schema/table paths for better organization, name mapping for existing Parquet files, scoped settings at schema and table levels, and partition transforms. The update includes automatic migration from v0.1 and adds new functions like ducklake\_list\_files for better system integration.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/76594dc2029c3428493aaf50499a7469?_a=AQAEulh)  
69
3. 3  
[](/posts/announcing-duckdb-1-4-0-kfezeepzk "Announcing DuckDB 1.4.0")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
7m read time • Sep 16, 2025  
### Announcing DuckDB 1.4.0  
DuckDB 1.4.0 'Andium' introduces Long Term Support with 1 year community maintenance, database encryption using AES-256, MERGE statement for upsert operations, Iceberg write support, CLI progress bar with ETA, FILL window function for interpolation, and performance improvements including sorting rework and materialized CTEs. The release also includes macOS notarization and moves Python integration to a separate repository.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/d6cb2f9a41df2bc6d09f7c19cd10b172?_a=AQAEulh)  
48  
1
4. 4  
[](/posts/faster-dashboards-with-multi-column-approximate-sorting-09niafbee "Faster Dashboards with Multi-Column Approximate Sorting")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
20m read time • Jun 06, 2025  
### Faster Dashboards with Multi-Column Approximate Sorting  
Advanced multi-column sorting techniques using space filling curves (Morton and Hilbert encodings) and truncated timestamps can significantly improve query performance on columnar data formats. These methods enable approximate sorting across multiple columns simultaneously, allowing diverse dashboard queries to benefit from min-max indexes and row group pruning. Experiments on flight data show Hilbert encoding provides the most consistent performance across different query patterns, while sorting by truncated timestamps (year-level granularity) combined with Hilbert encoding works best for time-filtered queries.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/b1cb7c111a9332e0a1862152e1ec82dd?_a=AQAEulh)  
42
5. 5  
[](/posts/announcing-duckdb-1-4-3-lts-rrbvtgrvg "Announcing DuckDB 1.4.3 LTS")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
4m read time • Dec 09, 2025  
### Announcing DuckDB 1.4.3 LTS  
DuckDB 1.4.3 LTS is now available with important bugfixes addressing correctness issues in HAVING clauses, JOIN operations, and indexed table updates. The release introduces beta support for Windows ARM64, including native extension distribution and Python wheels via PyPI. Benchmarks on TPC-H SF100 show 24% performance improvement for native ARM64 compared to emulated AMD64 on Snapdragon-based systems. Additional fixes include race condition crashes, memory management improvements during WAL replay, and various edge cases in Unicode handling and Parquet exports.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/b4a25d85eae64189b3b87ea2c24177a4?_a=AQAEulh)  
40  
1
6. 6  
[](/posts/announcing-duckdb-1-3-0-xuirbnaet "Announcing DuckDB 1.3.0")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
11m read time • May 21, 2025  
### Announcing DuckDB 1.3.0  
DuckDB version 1.3.0 introduces several new features and improvements, including external file caching, direct query capabilities via the CLI, Python-style lambda syntax, support for UUID v7, expression support in CREATE SECRET, and improved spatial join efficiency. The release also makes internal changes to enhance performance and reliability, particularly for Parquet file handling and string compression.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/913211aa5497229fdc78f5174e49723d?_a=AQAEuj9)  
37
7. 7  
[](/posts/preview-amazon-s3-tables-in-duckdb-zqoai2wez "Preview: Amazon S3 Tables in DuckDB")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
6m read time • Mar 14, 2025  
### Preview: Amazon S3 Tables in DuckDB  
DuckDB announces a new preview feature that supports Apache Iceberg REST Catalogs, enabling easy connection to Amazon S3 Tables and Amazon SageMaker Lakehouse. It allows DuckDB users to read and query Iceberg tables directly from these platforms. The guide provides detailed steps for installing necessary extensions from the core\_nightly repository and setting up S3 table buckets. The feature is currently experimental and a stable release is expected later in the year.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/9bbfa4251530eccd9813aedc78f9138c?_a=AQAEuj9)  
24
8. 8  
[](/posts/announcing-duckdb-1-4-2-lts-ip24vsodd "Announcing DuckDB 1.4.2 LTS")  
[![duckdb's profile](https://media.daily.dev/image/upload/s--3luD3Wei--/f_auto/v1714800008/logos/duckdb)](/sources/[source]/best-of/[year])  
5m read time • Nov 12, 2025  
### Announcing DuckDB 1.4.2 LTS  
DuckDB 1.4.2 LTS is now available with critical security fixes for database encryption vulnerabilities, new Iceberg extension support for insert/update/delete operations, enhanced logging and profiling capabilities including HTTP request timing, and Vortex file format support. The release also includes performance optimizations for WAL index operations and database detachment, plus fixes for crashes, incorrect results, and storage issues.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/d46b696ec9e6e59ab9867d25bc256275?_a=AQAEulh)  
23

[See all DuckDB archives](/sources/duckdb/best-of)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/duckdb/best-of/2025#page","url":"https://daily.dev/sources/duckdb/best-of/2025","name":"Best DuckDB Posts of 2025","description":"The most upvoted DuckDB posts of 2025, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/duckdb/best-of/2025#items","numberOfItems":8,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/the-duckdb-local-ui-yiozhryai","name":"The DuckDB Local UI"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/ducklake-0-2-jqqfxk39j","name":"DuckLake 0.2"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/announcing-duckdb-1-4-0-kfezeepzk","name":"Announcing DuckDB 1.4.0"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/faster-dashboards-with-multi-column-approximate-sorting-09niafbee","name":"Faster Dashboards with Multi-Column Approximate Sorting"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/announcing-duckdb-1-4-3-lts-rrbvtgrvg","name":"Announcing DuckDB 1.4.3 LTS"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/announcing-duckdb-1-3-0-xuirbnaet","name":"Announcing DuckDB 1.3.0"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/preview-amazon-s3-tables-in-duckdb-zqoai2wez","name":"Preview: Amazon S3 Tables in DuckDB"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/announcing-duckdb-1-4-2-lts-ip24vsodd","name":"Announcing DuckDB 1.4.2 LTS"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"DuckDB","item":"https://daily.dev/sources/duckdb"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/duckdb/best-of"},{"@type":"ListItem","position":5,"name":"2025"}]}]}
```

