DuckDB

Analytical SQL database that runs inside your own program without a server and can query CSV or Parquet files directly.

Tool Created External site

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.

More on this

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.

Show in the graph view