Webtagr - Technology News Summarizer

DuckDB 1.4.0 “Andium” Released: Database Encryption, MERGE Statement, and Iceberg Writes

2025-09-16

DuckDB v1.4.0, codenamed "Andium," is now available! This LTS release offers one year of community support and includes several key features: database file encryption using industry-standard AES, a new MERGE statement for flexible upsert operations (without requiring primary keys), and support for writing to Iceberg data lakes. Performance improvements, a new window function, and enhanced macOS support are also included. This release marks a significant step forward in DuckDB's capabilities and stability.

(duckdb.org)

Development LTS Release

DuckDB on a 2012 MacBook Pro: Did We Waste a Decade on Distributed Architectures?

2025-05-22

This article benchmarks DuckDB on a 2012 MacBook Pro to investigate whether the speed of hardware innovation has outpaced data growth, making distributed architectures unnecessary. The results show the decade-old laptop can complete complex analytical SQL queries, albeit slower than modern machines, but within reasonable timeframes. This leads to a reflection on the past decade's focus on distributed data analytics, suggesting single-node database technology was capable of handling large datasets back then, questioning the necessity of the shift towards distributed systems.

(duckdb.org)

Development

DuckDB Preview: Seamlessly Connect to Amazon S3 Tables and SageMaker Lakehouse

2025-03-18

DuckDB announces a preview feature adding support for Apache Iceberg REST Catalogs, enabling easy connection to Amazon S3 Tables and Amazon SageMaker Lakehouse. This collaboration between AWS and DuckDB Labs allows users to query Iceberg tables directly. By installing the latest DuckDB and necessary extensions, configuring AWS credentials, and using simple commands, users can access and query data, even with schema evolution. This preview release paves the way for a stable release later this year.

(duckdb.org)

Development

DuckDB Now Has a Built-in Local UI!

2025-03-12

The DuckDB team and MotherDuck are thrilled to announce a built-in local UI for DuckDB! This powerful web interface runs locally, eliminating the need for extra software. It features interactive notebooks, database browsing, table data preview, and data analysis tools, making interacting with DuckDB significantly easier. All queries are processed locally for enhanced data security. The UI also offers optional connection to MotherDuck cloud services for seamless data sharing and collaboration.

(duckdb.org)

Development Local UI