DuckDB

DuckDB
Developer(s)DuckDB Labs
Stable release
v1.1.3 / November 4, 2024 (2024-11-04)
Repository
Written inC++
Operating systemCross-platform
TypeColumn-oriented DBMS
RDBMS
LicenseMIT License
Websitewww.duckdb.org

DuckDB is an open-source column-oriented relational database management system (RDBMS). It is designed to provide high performance on complex queries against large databases in embedded configuration,[1] such as combining tables with hundreds of columns and billions of rows. Unlike other embedded databases (for example, SQLite) DuckDB is not focusing on transactional (OLTP) applications and instead is specialized for online analytical processing (OLAP) workloads.[2] The project has over 6 million downloads per month.[3][4][5]

  1. ^ Cite error: The named reference Kamphuis 2020 pp. 608–612 was invoked but never defined (see the help page).
  2. ^ Raasveldt, Mark; Mühleisen, Hannes (2019-06-25). DuckDB: an Embeddable Analytical Database. ACM. pp. 1981–1984. doi:10.1145/3299869.3320212. ISBN 978-1-4503-5643-5.
  3. ^ "PyPi Download Stats". www.pypistats.org. Archived from the original on 2024-08-13. Retrieved 2024-08-13.
  4. ^ "DuckDB Python Downloads Dashboard". duckdbstats.com. Archived from the original on 2024-08-13. Retrieved 2024-08-13.
  5. ^ Clark, Lindsay. "DuckDB Labs puts limit on free support, rules out VC funding". www.theregister.com. Archived from the original on 2024-03-23. Retrieved 2024-03-23.