{"repo":"Mooncake-Labs/pg_mooncake","free":true,"listed":false,"github":"https://github.com/Mooncake-Labs/pg_mooncake","clone":"git clone https://github.com/Mooncake-Labs/pg_mooncake.git","description":"Real-time analytics on Postgres tables","language":"Rust","stars":2000,"topics":["analytics","columnstore","delta-lake","iceberg","lakehouse","parquet","postgresql"],"license":"MIT","category":"analytics","readme_excerpt":"pg mooncake 🥮 Real-time analytics on Postgres tables [![][docs-shield]][docs-link] [![][license-shield]][license-link] [![][slack-shield]][slack-link] [![][x-shield]][x-link] Overview pg mooncake is a Postgres extension that creates a columnstore mirror of your Postgres tables in [Iceberg][iceberg-link], enabling fast analytics queries with sub-second freshness: - Real-time ingestion powered by [moonlink][moonlink-link] for streaming and batched INSERT/UPDATE/DELETE. - Fast analytics accelerated by [DuckDB][pgduckdb-link], ranking top 10 on [ClickBench][clickbench-link]. - Postgres-native allowing you to query a columnstore table just like a regular Postgres table. - Iceberg-native making your data readily accessible by other query engines. Installation Option 1: Docker For new users, we recommend using the Docker image to get started quickly: This will start Postgres with pg mooncake preinstalled. You can then connect to it using psql with the default user postgres : Option 2: From Source To build pg mooncake, first install [Rust][rust-install], [pgrx][pgrx-install], and [the build tools for DuckDB][duckdb-install]. Then, clone the repository: To build and install for Postgres versions 14-18, run: Finally, add pg mooncake to shared preload libraries in your postgresql.conf file and enable logical replication: For a complete walkthrough, refer to our [Dockerfile][dockerfile-link]. Quick Start First, create the pg mooncake extension: Next, create a regular Postgres table trad","default_branch":null,"files":null,"tree":[],"storefront":"/r/Mooncake-Labs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Mooncake-Labs/pg_mooncake/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."}