Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • CITATION.cff file
  • codemeta.json file
    Found codemeta.json file
  • .zenodo.json file
    Found .zenodo.json file
  • DOI references
  • Academic publication links
  • Academic email domains
  • Institutional organization owner
  • JOSS paper metadata
  • Scientific vocabulary similarity
    Low similarity (16.7%) to scientific vocabulary
Last synced: 7 months ago · JSON representation

Repository

Basic Info
  • Host: GitHub
  • Owner: duckdb
  • License: mit
  • Language: C++
  • Default Branch: main
  • Size: 277 MB
Statistics
  • Stars: 1
  • Watchers: 2
  • Forks: 2
  • Open Issues: 1
  • Releases: 0
Created about 2 years ago · Last pushed over 1 year ago
Metadata Files
Readme Contributing License Code of conduct Citation

README.md

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:

sql 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, Python3 and a C++11 compliant compiler. Run make in the root directory 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.

Owner

  • Name: DuckDB
  • Login: duckdb
  • Kind: organization
  • Location: Amsterdam, The Netherlands

GitHub Events

Total
  • Watch event: 1
  • Pull request event: 1
  • Fork event: 3
Last Year
  • Watch event: 1
  • Pull request event: 1
  • Fork event: 3

Issues and Pull Requests

Last synced: about 1 year ago

All Time
  • Total issues: 0
  • Total pull requests: 1
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Total issue authors: 0
  • Total pull request authors: 1
  • Average comments per issue: 0
  • Average comments per pull request: 0.0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 1
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 1
  • Average comments per issue: 0
  • Average comments per pull request: 0.0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Top Authors
Issue Authors
Pull Request Authors
  • szarnyasg (2)
Top Labels
Issue Labels
Pull Request Labels

Dependencies

.github/actions/build_extensions/action.yml actions
  • lukka/run-vcpkg v11.1 composite
.github/actions/manylinux_2014_setup/action.yml actions
  • hendrikmuhs/ccache-action v1.2.11 composite
  • lukka/run-vcpkg v11.1 composite
.github/actions/swap_space/action.yml actions
.github/actions/ubuntu_18_setup/action.yml actions
  • actions/checkout v3 composite
  • hendrikmuhs/ccache-action v1.2.11 composite
  • lukka/run-vcpkg v11.1 composite
.github/workflows/CheckIssueForCodeFormatting.yml actions
  • actions/checkout v4 composite
  • actions/setup-python v5 composite
.github/workflows/CodeQuality.yml actions
  • actions/checkout v3 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/DraftMe.yml actions
  • actions/upload-artifact v3 composite
.github/workflows/DraftMeNot.yml actions
.github/workflows/DraftPR.yml actions
  • actions/github-script v6 composite
.github/workflows/ExtendedTests.yml actions
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/ExtensionTrigger.yml actions
  • actions/checkout v3 composite
.github/workflows/ExtraTests.yml actions
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/InternalIssuesCreateMirror.yml actions
.github/workflows/InternalIssuesUpdateMirror.yml actions
.github/workflows/InvokeCI.yml actions
.github/workflows/IssuesCloseStale.yml actions
  • actions/stale v8 composite
.github/workflows/Julia.yml actions
  • actions/checkout v3 composite
  • hendrikmuhs/ccache-action main composite
  • julia-actions/setup-julia v1 composite
.github/workflows/LinuxRelease.yml actions
  • ./.github/actions/build_extensions * composite
  • ./.github/actions/manylinux_2014_setup * composite
  • ./.github/actions/ubuntu_18_setup * composite
  • KyleMayes/install-llvm-action v1 composite
  • actions/checkout v3 composite
  • actions/download-artifact v3 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/Main.yml actions
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/NeedsDocumentation.yml actions
.github/workflows/NightlyTests.yml actions
  • ./.github/actions/manylinux_2014_setup * composite
  • ./.github/actions/ubuntu_18_setup * composite
  • KyleMayes/install-llvm-action v1 composite
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • hendrikmuhs/ccache-action main composite
  • hendrikmuhs/ccache-action v1.2.11 composite
  • mymindstorm/setup-emsdk v12 composite
.github/workflows/OSX.yml actions
  • ./.github/actions/build_extensions * composite
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/PRNeedsMaintainerApproval.yml actions
.github/workflows/Python.yml actions
  • ./.github/actions/build_extensions * composite
  • ./.github/actions/manylinux_2014_setup * composite
  • actions/checkout v3 composite
  • actions/download-artifact v3 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • docker/setup-qemu-action v2 composite
  • hendrikmuhs/ccache-action main composite
  • hendrikmuhs/ccache-action v1.2.11 composite
.github/workflows/R.yml actions
  • ./.github/actions/build_extensions * composite
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • hendrikmuhs/ccache-action main composite
  • r-lib/actions/setup-r v2 composite
.github/workflows/R_CMD_CHECK.yml actions
  • actions/checkout v3 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/Regression.yml actions
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • hendrikmuhs/ccache-action main composite
.github/workflows/Swift.yml actions
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
.github/workflows/SwiftRelease.yml actions
  • actions/checkout v3 composite
.github/workflows/TwineUpload.yml actions
  • actions/setup-python v5 composite
.github/workflows/Wasm.yml actions
  • actions/checkout v3 composite
  • actions/download-artifact v3 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • hendrikmuhs/ccache-action main composite
  • lukka/run-vcpkg v11.1 composite
  • mymindstorm/setup-emsdk v12 composite
.github/workflows/Windows.yml actions
  • ./.github/actions/build_extensions * composite
  • actions/checkout v3 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • hendrikmuhs/ccache-action main composite
  • ilammy/msvc-dev-cmd v1 composite
  • msys2/setup-msys2 v2 composite
.github/workflows/_extension_client_tests.yml actions
  • actions/checkout v2 composite
  • actions/setup-python v5 composite
.github/workflows/cifuzz.yml actions
  • actions/upload-artifact v1 composite
  • google/oss-fuzz/infra/cifuzz/actions/build_fuzzers master composite
  • google/oss-fuzz/infra/cifuzz/actions/run_fuzzers master composite
.github/workflows/coverity.yml actions
  • actions/checkout v4 composite
  • actions/setup-python v5 composite
extension/httpfs/vcpkg.json vcpkg
  • openssl *
.github/workflows/StagedUpload.yml actions
  • actions/checkout v3 composite
  • actions/setup-python v4 composite
.github/workflows/DockerTests.yml actions
  • actions/checkout v3 composite
.github/workflows/OnTag.yml actions
.github/workflows/Pyodide.yml actions
  • actions/checkout v4 composite
  • actions/setup-node v4 composite
  • actions/setup-python v5 composite
  • actions/upload-artifact v3 composite
  • mymindstorm/setup-emsdk v14 composite
.github/workflows/Android.yml actions
  • ./.github/actions/ubuntu_18_setup * composite
  • actions/checkout v3 composite
  • actions/upload-artifact v3 composite
tools/pythonpkg/pyproject.toml pypi
tools/pythonpkg/requirements-dev.txt pypi
  • adbc_driver_manager * development
  • cxxheaderparser * development
  • fsspec * development
  • mypy * development
  • numpy >=1.14 development
  • pandas * development
  • pcpp * development
  • polars * development
  • psutil >=5.9.0 development
  • pyarrow >=8.0 development
  • pybind11 >=2.6.0 development
  • pytest * development
  • pytest-timeout * development
  • requests >=2.26 development
  • setuptools >=58 development
  • setuptools_scm >=6.3 development
  • tensorflow * development
  • torch * development
tools/pythonpkg/setup.py pypi
extension/delta/vcpkg.json vcpkg
  • openssl *