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 fast in-process analytical database: Installation | Resources

    Overview

    DuckDB is an embedded database, so it does not require deployment or service management. You only need to install the DuckDB package on the node to use it.

    Installation

    Pigsty already provides DuckDB software package (RPM / DEB) in the Infra software repository, you can install it with the following command:

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

    Resources

    There are some DuckDB-related extension plugins provided by Pigsty for PostgreSQL:

    • pg_analytics: Add OLAP capabilities to PostgreSQL based on DuckDB
    • pg_lakehouse: Data lakehouse plugin by ParadeDB, wrapping DuckDB. (Currently planned to be renamed back to pg_analytics)
    • duckdb_fdw: Foreign data wrapper for DuckDB, read/write DuckDB data files from PG
    • pg_duckdb: WIP extension plugin by DuckDB official MotherDuck and Hydra (only available on EL systems as a pilot)