DuckDB v1.4 introduces support for data-at-rest encryption using AES-GCM and AES-CTR ciphers. The article details how to implement encryption, manage keys, and the structure of encrypted data within DuckDB. It also highlights performance considerations and current limitations in compliance with NIST standards.

This article critiques SQL's complexities and inefficiencies while highlighting alternatives like DuckDB. It discusses common frustrations with SQL syntax and suggests ways to enhance usability, including more intuitive commands and error handling.

This article explains the optimization rules in DuckDB, focusing on how its advanced optimizer enhances query performance. It details the optimizer's structure, core functions, and how to implement custom optimization rules. A brief overview of 26 built-in optimization rules is also provided.

The article discusses the features and capabilities of DuckDB, a high-performance analytical database management system designed for data analytics. It highlights its integration with various data sources and its usability in data science workflows, emphasizing its efficiency and ease of use.

The article discusses spatial joins in DuckDB, highlighting their significance in efficiently combining datasets based on geographic relationships. It provides insights into various types of spatial joins and their implementation, showcasing the capabilities of DuckDB in handling spatial data analysis.

DuckDB 0.14.0 has been released, featuring significant enhancements and new functionalities aimed at improving performance and usability. Key updates include support for new data types, optimizations for query execution, and better integration with various programming environments. This release continues DuckDB's commitment to providing a powerful analytical database for data science and analytics tasks.

The podcast discusses DuckDB, an emerging database technology that offers powerful analytics capabilities and flexibility. It highlights its growing ecosystem, including integrations and community contributions, positioning DuckDB as a competitive option in the data management landscape.

The article discusses the transition from using DuckDB, a powerful analytical database, to Duckhouse, a new framework designed to enhance data analysis capabilities. It highlights the features and improvements that Duckhouse offers, aiming to streamline data processing and analytics workflows. The author emphasizes the importance of this evolution for data professionals seeking more efficient tools.

GTFS is a standardized format for public transportation data that enables interoperability across various transit applications. This article explains how to create a DuckDB database to analyze GTFS Schedule datasets, detailing the necessary steps for loading and querying the data from example datasets.