Get the latest tech news
Pg_lakehouse: A DuckDB Alternative in Postgres
pg_lakehouse: A DuckDB Alternative in Postgres Written by Ming Ying on June 3, 2024 Our newest extension, pg_lakehouse, transforms Postgres into a DuckDB alternative. Like DuckDB, pg_lakehouse allows Postgres to directly query external object stores like S3, table formats like Delta Lake, and file formats like Parquet.
If the query fails for any reason inside DataFusion, it gracefully falls back to Postgres. We’ve provided an example Parquet file of 3 million NYC taxi trips hosted in a public S3 bucket for testing. Adding write support will enable developers to further centralize data lake operations inside Postgres.
Or read this on Hacker News