About this project
DuckDB is an analytical database system that provides a rich SQL dialect supporting window functions, nested correlated subqueries, and complex types such as arrays, structs, and maps. It is designed to be portable and easy to deploy, available as a standalone CLI application and through clients for Python, R, Java, and Wasm. It features deep integrations with data analysis tools like pandas and dplyr.
Key capabilities include:
- Direct data import from CSV and Parquet files via SQL FROM clauses.
- Support for various extensions to enhance SQL usability.
- In-process architecture for high-performance analytical workloads.
For developers, the project is built using CMake and requires a C++17 compliant compiler and Python 3.