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 | spinov001@gmail.com