# 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)