Architecture
DuckDB: Fast Analytics Without Moving Data
DuckDB is an embedded, columnar, vectorized SQL engine that runs inside your own process and queries Parquet, CSV, JSON, S3, and URLs in place. For DuckDB analytics up to a hundred gigabytes it beats pandas on speed and a cloud warehouse on friction cost. It is not a transactional engine. Version 1.0 landed in June 2024.