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