Get the latest tech news

Pg_lakehouse: Query Any Data Lake from Postgres


Postgres for Search and Analytics. Contribute to paradedb/paradedb development by creating an account on GitHub.

pg_lakehouse is an extension that transforms Postgres into an analytical query engine over object stores like S3 and table formats like Delta Lake. Lack of support for most object stores, file, and table formats Too slow over large datasets to be a viable analytical engine The following example uses pg_lakehouse to query an example dataset of 3 million NYC taxi trips from January 2024, hosted in a public S3 bucket provided by ParadeDB.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Postgres

Postgres

Photo of data lake

data lake

Photo of pg_lakehouse

pg_lakehouse

Related news:

News photo

Show HN: An SQS Alternative on Postgres

News photo

Crunchy Bridge for Analytics: Your Data Lake in PostgreSQL

News photo

Common DB schema change mistakes in Postgres