Skip to content
Docs Extensions Blog Pricing 中文 GitHub

This is the multi-page printable view of this section. .

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

    The current Pigsty node platform mapping includes the duckdb package, which can be installed directly from the Infra repository:

    ./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, the official DuckDB PostgreSQL extension
    • pg_mooncake, builds on pg_duckdb with columnar engine and sync
    • pg_analytics, high-performance OLAP built on DuckDB; the project is archived and has been removed from the current Pigsty extension catalog
    • duckdb_fdw, a DuckDB foreign data wrapper for reading and writing DuckDB files from PostgreSQL