Databases Analytics DB stable

DuckDB

In-process analytical database (SQLite for analytics)

28.0K stars 300 contributors Since 2020
Website → GitHub

In-process analytical database (SQLite for analytics)

License
MIT
Min RAM
256 MB
Min CPUs
1 core
Scaling
single_node
Complexity
beginner
Performance
medium
Self-hostable
✓
K8s native
✕
Offline
✓
Pricing
fully free
Docs quality
good
Vendor lock-in
none

Use cases

  • ✓ Primary use: local-analytics
  • ✓ Primary use: data-science
  • ✓ Primary use: etl

Replaces / alternatives to

  • SQLite for OLAP
  • Pandas for SQL

Technical specs

Language
C++
API type
REST
Protocols
HTTP
Data model
column
Deployment
dockeraptbinary

Community

GitHub stars 28.0K
Contributors 300
Commit frequency weekly
Plugin ecosystem none
Backing DuckDB Foundation
Funding foundation

Release

Latest version —
Last release —
Since 2020

Best fit

Team size
solosmallmediumenterprise
Industries
general

Tags

  • in-process
  • columnar
  • parquet
  • csv
  • analytical
  • embedded