DuckDB
columnar analytics
Open Source
In-process OLAP database for fast local analytics
Pricing Model
Free and open source
Free tier: Completely free
Supported Languages
Pros and Cons
Ventajas
- + Extremely fast for OLAP queries
- + Zero configuration, embedded
- + Excellent Pandas/Arrow integration
- + Reads Parquet, CSV, JSON directly
- + Lightweight and portable
Desventajas
- - Not for concurrent OLTP workloads
- - Single-node only
- - Relatively new ecosystem
Casos de Uso
- Local data analysis
- ETL and data transformations
- Jupyter notebook analytics
- Log file processing