DuckDB
An in-process analytical database, the SQLite of analytics: query Parquet, CSV and data frames on your laptop. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- DuckDB Labs
- Created by
- Mark Raasveldt, Hannes Mühleisen
- First release
- 2019
- License
- MIT
- Open source
- Yes
- Pricing
- Free
- Website
- https://duckdb.org
- Written in
- C++
- Data model
- Relational
- Storage layout
- Column-oriented
- Workload
- Analytics (OLAP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Embedded
- Scaling
- Single node
- Create, read, update, delete
- Create: fast (Fast bulk appends); Read: fast (Vectorized scans and aggregations); Update: moderate (Fine in bulk, slow row by row); Delete: moderate (Fine in bulk, slow row by row)