Module: DuckDB

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