DuckDB

About DuckDB

DuckDB is an analytical database that runs within a process and can query formats such as Parquet and CSV. Start with a few files, inspect how their columns are interpreted and compare an aggregate with a known result. The setup is useful for local analysis, scripts and repeatable processing where running a separate database server would add work. It is still worth testing data sizes, memory and disk use for the operations you intend to run. If several people need to write to shared data, check the project’s concurrency model. Use representative data and a real query when comparing it with a warehouse or another local tool.