OLTP and OLAP: two workloads, different priorities
Understand why checking out a shopping basket and analyzing a year of sales ask very different things of a database.
DuckDB.
An analytical SQL database that runs inside your process and queries files directly.
Official documentationWhere it fits
An analytical SQL database that runs inside your process and queries files directly.
This profile covers a analytical database in the Analytics & warehouses category.
Evaluate it for your workload
Start with your access patterns, data size, concurrency, and recovery requirements. Check the official documentation for the exact edition, engine version, and deployment model you intend to use.
For self-managed deployments, account for upgrades, monitoring, access controls, and the process for recovering your data.
Learn by doing
Related guides appear below as they complete editorial review. Use those examples as a starting point for testing a representative development workload.
Put it into practice.
Guides & tutorialsAnalyze a Parquet file with DuckDB and SQL
Go from a local file to a useful analytical query without standing up a database server.