{"repo":"relytcloud/pg_ducklake","free":true,"listed":false,"github":"https://github.com/relytcloud/pg_ducklake","clone":"git clone https://github.com/relytcloud/pg_ducklake.git","description":"Native lakehouse experience in Postgres powered by DuckDB & Ducklake","language":"C++","stars":126,"topics":["analytics","duckdb","ducklake","lakehouse","postgresql","postgresql-extension"],"license":"MIT","category":"databases-storage","readme_excerpt":"pg ducklake Native data lakehouse in PostgreSQL, powered by DuckLake (a lakehouse format built on SQL database and Parquet files). Key Features - Managed DuckLake tables : create, write, and query DuckLake tables in PostgreSQL via SQL (e.g. psql/JDBC), with full lakehouse features -- time travel, transactions, partitioning, and sort keys. - Fast Analytics : DuckLake tables are stored columnar and analyzed by DuckDB. Hybrid queries that join them with heap tables are also supported. - Realtime Ingestion : with data inlining, small writes are buffered in the catalog (fast, avoids the small files problem) and are immediately visible to all readers. - CDC Support : incremental heap-to-DuckLake conversion with pg duckpipe. - DuckDB compatibility : tables created by pg ducklake are directly queryable from DuckDB clients. See it in action Your first Data Lake in PostgreSQL Access your data with external DuckDB Quick Start Docker Run PostgreSQL with pg ducklake pre-installed in a docker container: Compile from source Requirements: - PostgreSQL : 14, 15, 16, 17, 18 - Operating Systems : Ubuntu 22.04-24.04, macOS See documentation for detailed instructions. Usecases For a detailed comparison of upstream DuckLake features and what pg ducklake currently supports, see DuckLake Feature Coverage. Convert a PostgreSQL heap table into a DuckLake table This pattern performs a one-time ETL copy from row-store (PostgreSQL heap) tables to DuckLake (column-store) tables for fast analytics, while O","default_branch":null,"files":null,"tree":[],"storefront":"/r/relytcloud","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/relytcloud/pg_ducklake/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}