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, the

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