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

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