DuckDB

An in-process SQL OLAP database management system

★ 4.6

In-process SQL OLAP database. 'SQLite for analytics' - fast analytical queries on local data. Perfect for data science, ETL, and embedded analytics.

free

Tarification

Yes

Self-Hostable

Visiter le Site Web → Voir la Documentation

Fonctionnalités

✓ In-process (no server needed)
✓ Columnar storage for analytics
✓ Full SQL support
✓ Direct Parquet/CSV/JSON querying
✓ Parallel query execution
✓ Zero dependencies
✓ Python/R deep integration
✓ Cross-platform

Avantages

+ Blazing fast analytical queries
+ No server setup needed
+ Query files directly (Parquet, CSV)
+ Excellent Python integration
+ Modern SQL features

Inconvénients

− Not for OLTP workloads
− Single-machine only
− Newer project (less battle-tested)
− No built-in replication