Introducing pg_duckdb, an open-source Postgres extension embedding DuckDB’s analytics engine for fast analytical queries within Postgres. Postgres, named 2023 DBMS of the Year, excels at transactions but falls short in analytics. DuckDB, with its vectorized query engine, is designed for processing analytical questions efficiently. The collaboration between DuckDB Labs, MotherDuck, Hydra, Neon, and Microsoft aims to create a seamless extension combining the strengths of both databases. The pg_duckdb extension offers MotherDuck cloud support, seamless Postgres storage integration, full compatibility with Postgres data types and functions, and high-quality lakehouse integration. Contributions and feedback are welcomed for this ambitious open-source project.
https://motherduck.com/blog/pg_duckdb-postgresql-extension-for-duckdb-motherduck/