DuckDB
Analytical SQL database that runs inside your own program without a server and can query CSV or Parquet files directly.
DuckDB is built for analysis: sums, groupings and comparisons across many rows. It is not installed as a service but embedded as a library, for example in Python.
Typical use
One file per day in a folder, one SQL query across them, results in seconds. No separate database server is needed.
Used in
- Price and Stock Tracker Streamlit app that reads a supplier's daily article list and stores only changes in price, stock and listing in DuckDB, with price index and stock movements.
Mentioned
- Python General-purpose programming language with highly readable syntax. The standard for data analysis, automation and quick prototypes.