DuckDB

In-process analytical database optimized for OLAP workloads.

Configuration

Basic Usage

Analytical Queries

DuckDB excels at complex analytical queries with window functions and aggregations.

File Format Support

Query and export Parquet, CSV, and JSON files directly.

Connection Pooling

When to Use DuckDB

✅ Analytics & Reporting

Aggregations, window functions, complex joins

✅ Data Transformation

ETL pipelines, data processing

✅ File-Based Queries

Direct Parquet, CSV, JSON querying

✅ Embedded Analytics

Add analytics without a separate database server

⚠️ Not for OLTP

For transactional workloads, use PostgreSQL or SQLite

Features

Feature Support
In-Memory Database✅
File-Based Storage✅
Parquet Read/Write✅
CSV Read/Write✅
JSON Queries✅
Window Functions✅
CTEs✅
Connection Pooling✅
Async Operations✅ (via spawn_blocking)