amalgame-duckdb

Overview

DuckDB is the SQLite of analytics: embedded, server-less, but built for OLAP queries — vectorized execution, parallelism across all cores, direct Parquet and CSV read/write. The package vendors the DuckDB library and exposes it through an API identical to the sqlite package (drop-in for basic queries).

Features

• ✓Vectorized execution — much faster than SQLite on aggregations
• ✓Native Parquet, CSV, JSON read/write
• ✓SQL compatible (extended PostgreSQL dialect)
• ✓API aligned with the sqlite package — minimal learning curve
• ✓MIT License

Example

Minimal usage example — copy-paste runnable after install.

amc package add duckdb

let db = DuckDB.Open("analytics.duckdb")
db.Exec("CREATE TABLE sales AS SELECT * FROM read_csv('sales.csv')")
let top = db.Query("SELECT region, SUM(amount) FROM sales GROUP BY region")

Related packages