DuckDB Is a Free In-Process Analytics Database

DuckDB is SQLite for analytics. Query CSV, Parquet, JSON, and pandas DataFrames with SQL — no server needed.

import duckdb
result = duckdb.sql("SELECT * FROM read_csv_auto(data.csv) WHERE age > 25")
result = duckdb.sql("SELECT category, SUM(sales) FROM sales.parquet GROUP BY 1")

Columnar storage, full SQL, Python/R/Node.js/Go SDKs. 26K+ GitHub stars.

---

Apify tools | [e-mail]