Module: DuckDB

DuckDB is a fast in-process analytical database

Overview

DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs.

Install

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

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

Resource

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

• pg_lakehouse: Access external files from S3/MinIO through DuckDB
• pg_analytics: Add OLAP capabilities to PostgreSQL based on DuckDB
• 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