Module: DuckDB

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)