📊DuckDB
Also known as Duck DB
A small database for sums and counts. It runs inside your own program.
Think of it like
It is like a small tool you keep in your pocket for data. There is no server to set up. It just runs where you are.
Example
An analyst downloads 2 GB of Parquet files. On her laptop, DuckDB queries them in seconds. She never needs a login to the warehouse.
Why it matters
Much analysis does not need a cluster. DuckDB makes a laptop enough for data that once needed a warehouse.
Definition
Example code
sql
SELECT country, COUNT(*) AS orders
FROM 'orders.parquet'
GROUP BY country
ORDER BY orders DESC;Common mistake
Key takeaways
- 1In-process. Runs inside your program.
- 2Column storage. Fast sums and group-bys.
- 3Reads files. CSV and Parquet, no loading.