×
DuckDB

[Infographic] Highlights | Database New Features in March 2026

Discover the latest database product updates for March 2026 in our informative infographic!

When DuckDB Embraces MySQL in the AI Era

AliSQL enhances MySQL with DuckDB-powered analytical instances for high-performance HTAP capabilities while maintaining full MySQL compatibility.

AliSQL DuckDB: Data Compression and Archiving Analysis Practices

This article explains how AliSQL natively supports high-density storage and efficient analysis by deeply integrating DuckDB while maintaining compatibility with the MySQL ecosystem.

When MySQL Meets the Columnar Storage Engine DuckDB in the AI Era

AliSQL integrates DuckDB as a storage engine to add high-performance OLAP capabilities to MySQL while maintaining full compatibility.

From Storage Engines to Binlogs: Why MySQL’s DuckDB Integration is More Elegant than PostgreSQL’s

We see that currently there are 3 mainstream solutions running: pg_duckdb, pg_mooncake, and pg_lake.

PolarDB's New Open Source Project: DuckDB-paimon, Helping Enterprises Build an AI-Oriented Multi-Model Data Foundation

This article introduces DuckDB-paimon, an open-source PolarDB extension that lets DuckDB query Apache Paimon data lakes natively without external clusters.

DuckDB Internals - Part 7: Join Reordering Optimization

This article explains the Join Reorder optimization algorithm used by DuckDB.

DuckDB Internals - Part 6: DuckDB LocalStorage

This article explains how DuckDB’s LocalStorage efficiently handles INSERT operations within transactions using a shadow-table design and optimistic merging for bulk data.

DuckDB Internals - Part 5: The Transaction Lifecycle

This article focuses on the start, commit, and rollback of a transaction from the perspective of its lifecycle.

DuckDB's MVCC Design and the HyPer Model

The article explains DuckDB’s HyPer-inspired MVCC design, which uses transaction IDs and timestamps for simple, efficient visibility checks without read views.

Alibaba Cloud ApsaraDB RDS for PostgreSQL 18: The Premier Data Foundation for AI Applications

The article introduces Alibaba Cloud ApsaraDB RDS for PostgreSQL 18 as an AI-optimized, enterprise-grade database to serve as a premier data foundation for AI applications.

Are ETL and Wide Tables Still Necessary? Analysis of DuckDB-based Analytical Instances for ApsaraDB RDS for MySQL

This article introduces the performance benefits of DuckDB-based analytical instances for ApsaraDB RDS for MySQL, and discusses whether ETL and wide tables are still necessary.

A Deep Dive into PolarDB for PostgreSQL IMCI and its Integration with DuckDB

This article introduces how Alibaba Cloud's PolarDB for PostgreSQL enables real-time HTAP through its In-Memory Columnar Index (IMCI) and integration with DuckDB.

DuckDB Internals - Part 4: Optimizer Overview

This article will focus on explaining the purpose of all optimization rules implemented in DuckDB.

DuckDB Internals - Part 3: Execution Layer Overview

This article introduce the main concepts involved in each module of the execution layer, giving readers a general understanding of what each module does.

DuckDB Internals - Part 2: Table Storage Format

This article provides a detailed analysis of the table storage format based on the DuckDB v1.3.1 source code.

DuckDB on ApsaraDB RDS for Lightning-Fast Analytics

This article introduces how Alibaba Cloud has integrated DuckDB into MySQL as a new storage engine to dramatically improve its analytical query performance.

DuckDB Internals - Part 1: File Format Overview

This article primarily focused on the file format overview and metadata storage.

How to Determine Whether the Current PostgreSQL Database is in a Consistent State?

This article introduces how to determine whether the current PostgreSQL database is in a consistent state.