This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Module: DuckDB

Install DuckDB, a high-performance embedded analytical database component.

    DuckDB is a high-performance embedded analytical database.

    DuckDB is embedded, so it does not require deployment or service management. Install the DuckDB package on the node and use it directly.

    Installation

    Pigsty Infra repo provides latest DuckDB RPM/DEB packages, install directly:

    ./node.yml -t node_install  -e '{"node_repo_modules":"infra","node_packages":["duckdb"]}'

    Install with pig:

    pig repo add infra -u      # add Infra repo
pig install duckdb         # install DuckDB package

    Resources

    Pigsty provides DuckDB-related PostgreSQL extensions:

    • pg_duckdb, an extension by DuckDB official MotherDuck and Hydra
    • pg_mooncake, builds on pg_duckdb with columnar engine and sync
    • pg_analytics, OLAP on DuckDB, archived
    • duckdb_fdw, DuckDB FDW to read/write DuckDB files from PG, not updated yet