duckdb

DuckDB is an analytical in-process SQL database management system

Latest version: 1.5.2 registry icon
Maintenance score
100
Safety score
90
Popularity score
100
Check your open source dependency risks. Get immediate insight about security, stability and licensing risks.
Security
  Vulnerabilities
Version Suggest Low Medium High Critical
1.5.2 0 0 0 0 0
1.5.1 0 0 0 0 0
1.5.0 0 0 0 0 0
1.4.4 0 0 0 0 0
1.4.3 0 0 0 0 0
1.4.2 0 0 0 0 0
1.4.1 0 0 0 0 0
1.4.0 0 0 0 0 0
1.3.2 0 0 0 0 0
1.3.1 0 0 0 0 0
1.3.0 0 0 0 0 0
1.2.2 0 0 0 0 0
1.2.1 0 0 0 0 0
1.2.0 0 0 0 0 0
1.1.3 0 0 0 0 0
1.1.2 0 0 0 0 0
1.1.1 0 0 0 0 0
1.1.0 0 0 0 0 0
1.0.0 0 0 0 1 0
0.10.3 0 0 0 0 0
0.10.2 0 0 0 0 0
0.10.1 0 0 0 0 0
0.10.0 0 0 0 0 0
0.9.2 0 0 0 0 1
0.9.1 0 0 0 0 1
0.9.0 0 0 0 0 1
0.8.1 0 0 0 0 1
0.8.0 0 0 0 0 1
0.7.1 0 0 0 0 1
0.7.0 0 0 0 0 1
0.6.1 0 0 0 0 1
0.6.0 0 0 0 0 1
0.5.1 0 0 0 0 1
0.5.0 0 0 0 0 1
0.4.0 0 0 0 0 1
0.3.4 0 0 0 0 1
0.3.3 0 0 0 0 1
0.3.2 0 0 0 0 1
0.3.1 0 0 0 0 1
0.3.0 0 0 0 0 1
0.2.9 0 0 0 0 1
0.2.8 0 0 0 0 1
0.2.7 0 0 0 0 1
0.2.6 0 0 0 0 1
0.2.5 0 0 0 0 1
0.2.4 0 0 0 0 1
0.2.3 0 0 0 0 1
0.2.2 0 0 0 0 1
0.2.1 0 0 0 0 1
0.2.0 0 0 0 0 1
0.1.9 0 0 0 0 1
0.1.8 0 0 0 0 1
0.1.7 0 0 0 0 1
0.1.6 0 0 0 0 1
0.1.5 0 0 0 0 1
0.1.3 0 0 0 0 1
0.1.2 0 0 0 0 1
0.1.1 0 0 0 0 1
0.1.0 0 0 0 0 1
0.0.3 0 0 0 0 1
0.0.2 0 0 0 0 1
0.0.0 0 0 0 0 1

Stability
Latest release:

1.5.2 - This version is safe to use because it has no known security vulnerabilities at this time. Find out if your coding project uses this component and get notified of any reported security vulnerabilities with Meterian-X Open Source Security Platform

Licensing

Maintain your licence declarations and avoid unwanted licences to protect your IP the way you intended.

MIT   -   MIT License

Not a wildcard

Not proprietary

OSI Compliant



DuckDB logo

Github Actions Badge discord Latest Release

DuckDB

DuckDB is a high-performance analytical database system. It is designed to be fast, reliable, portable, and easy to use. DuckDB provides a rich SQL dialect with support far beyond basic SQL. DuckDB supports arbitrary and nested correlated subqueries, window functions, collations, complex types (arrays, structs, maps), and several extensions designed to make SQL easier to use.

DuckDB is available as a standalone CLI application and has clients for Python, R, Java, Wasm, etc., with deep integrations with packages such as pandas and dplyr.

For more information on using DuckDB, please refer to the DuckDB documentation.

Installation

If you want to install DuckDB, please see our installation page for instructions.

Data Import

For CSV files and Parquet files, data import is as simple as referencing the file in the FROM clause:

SELECT * FROM 'myfile.csv';
SELECT * FROM 'myfile.parquet';

Refer to our Data Import section for more information.

SQL Reference

The documentation contains a SQL introduction and reference.

Development

For development, DuckDB requires CMake, Python 3 and a C++17 compliant compiler. In the root directory, run make to compile the sources. For development, use make debug to build a non-optimized debug version. You should run make unit and make allunit to verify that your version works properly after making changes. To test performance, you can run BUILD_BENCHMARK=1 BUILD_TPCH=1 make and then perform several standard benchmarks from the root directory by executing ./build/release/benchmark/benchmark_runner. The details of benchmarks are in our Benchmark Guide.

Please also refer to our Build Guide and Contribution Guide.

Support

See the Support Options page and the dedicated endoflife.date page.