TECHNOLOGY PROFILE · TECH-0062
DuckDB
Embedded analytical SQL database.
Reference link only — not reviewed this edition. This profile preserves the prepared catalog’s original descriptions. Advantages depend on the workload; comparisons are editorial, not benchmark results.
Where it has an edge
Queries local files directly without running a separate database service, unlike server-oriented warehouses.
Best-fit problems
Exploring Parquet datasets, feature joins and local analytics.
Tradeoffs & cautions
Not a default high-concurrency transactional application database.
What to test before choosing
Measure wall time, peak memory and IO on a representative dataset; verify numerical and schema equivalence.
Runtime & hardware
Local CPU; GPU where stated
Access & licensing
Open-source core; verify component licenses
Execution
Local / self-hosted
Lifecycle
Not independently audited
Comparison basis
Editorial problem-fit judgement; no head-to-head benchmark performed
Connected concepts
Alternatives to investigate
SQLite · Polars · PostgreSQL