DuckDB

Use it when

• query Parquet, CSV, JSON, and local data with analytical SQL
• run fast embedded analytics without deploying a database server

What it solves

Not the fit when

• not a distributed multi-user warehouse

Install

pip install duckdb

Invoke

import duckdb; rows = duckdb.sql("select * from read_parquet('data/*.parquet')").fetchall()

Alternatives

No reviewed alternatives recorded yet.