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.
- Tags