pg_quack

v0.0.1+5a49c79
Keywords
duckdb
analytics
embedded

pg_quack

pg_quack is PostgreSQL with Embedded DuckDB :duck:

Installation

With pgxman

  1. Install pgxman
  2. pgxman install pg_quack

From source

  1. make install
  2. (Optional) Create quack directory and set permissions so PostgreSQL process can write to it. Directory can be changed with quack.data_dir configuration parameter. By default, the directory is quack in your Postgres data directory.
postgres=# show quack.data_dir ;
           quack.data_dir
------------------------------------
 /opt/database/postgres/data/quack/
(1 row)

Usage

CREATE TABLE quack_test (...) USING quack;

Limitations

  • PG 14 and PG 15 only (PG 16 is not yet supported)
  • Only COPY, INSERT, and SELECT are supported.
  • Only single connection can execute INSERT and SELECT against quack table
  • Limited support for only basic data types
  • You cannot query between quack tables and other storage methods (including Postgres heap tables).