public inbox for [email protected]help / color / mirror / Atom feed
Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension) 3+ messages / 2 participants [nested] [flat]
* Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension) @ 2026-05-20 12:26 Pratik Pandit <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Pratik Pandit @ 2026-05-20 12:26 UTC (permalink / raw) To: [email protected] Hi everyone, I am looking to handle document-store workloads directly inside PostgreSQL, but using MongoDB-style query patterns or optimized storage structures. To give an analogy: I highly appreciate how pgvector brings native vector data types and specialized indexing (like HNSW) directly into Postgres, keeping everything inside the same database engine. I know Postgres has incredible jsonb capabilities natively, but I am looking for a PostgreSQL extension that bridges the gap closer to MongoDB. Specifically, I'm hoping to find something that provides: 1. A Native BSON Data Type: Storing binary JSON natively inside Postgres for faster processing. 2. MongoDB API/Query Compatibility: The ability to run Mongo-like queries directly on top of Postgres tables. I am already aware of Foreign Data Wrappers like mongo_fdw, but that is for querying a separate, external MongoDB instance. I want to keep the data *natively resident* inside Postgres. Are there any active open-source extensions or projects that the community recommends for this? (I have heard brief mentions of things like pg_documentdb / FerretDB, but I'd like to get the community's perspective on what is production-ready extension for it). Best regards, Pratik Pandit ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension) @ 2026-05-20 13:31 Jim Mlodgenski <[email protected]> parent: Pratik Pandit <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Jim Mlodgenski @ 2026-05-20 13:31 UTC (permalink / raw) To: Pratik Pandit <[email protected]>; +Cc: [email protected] On Wed, May 20, 2026 at 8:26 AM Pratik Pandit <[email protected]> wrote: > > Hi everyone, > > I am looking to handle document-store workloads directly inside PostgreSQL, but using MongoDB-style query patterns or optimized storage structures. > > To give an analogy: I highly appreciate how pgvector brings native vector data types and specialized indexing (like HNSW) directly into Postgres, keeping everything inside the same database engine. > > I know Postgres has incredible jsonb capabilities natively, but I am looking for a PostgreSQL extension that bridges the gap closer to MongoDB. Specifically, I'm hoping to find something that provides: > 1. A Native BSON Data Type: Storing binary JSON natively inside Postgres for faster processing. > 2. MongoDB API/Query Compatibility: The ability to run Mongo-like queries directly on top of Postgres tables. > > I am already aware of Foreign Data Wrappers like mongo_fdw, but that is for querying a separate, external MongoDB instance. I want to keep the data natively resident inside Postgres. > > Are there any active open-source extensions or projects that the community recommends for this? (I have heard brief mentions of things like pg_documentdb / FerretDB, but I'd like to get the community's perspective on what is production-ready extension for it). > This is a high quality project https://github.com/documentdb/documentdb ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension) @ 2026-05-21 05:56 Pratik Pandit <[email protected]> parent: Jim Mlodgenski <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Pratik Pandit @ 2026-05-21 05:56 UTC (permalink / raw) To: Jim Mlodgenski <[email protected]>; +Cc: [email protected] Thanks, I'll check it out. On Wed, May 20, 2026 at 7:01 PM Jim Mlodgenski <[email protected]> wrote: > On Wed, May 20, 2026 at 8:26 AM Pratik Pandit > <[email protected]> wrote: > > > > Hi everyone, > > > > I am looking to handle document-store workloads directly inside > PostgreSQL, but using MongoDB-style query patterns or optimized storage > structures. > > > > To give an analogy: I highly appreciate how pgvector brings native > vector data types and specialized indexing (like HNSW) directly into > Postgres, keeping everything inside the same database engine. > > > > I know Postgres has incredible jsonb capabilities natively, but I am > looking for a PostgreSQL extension that bridges the gap closer to MongoDB. > Specifically, I'm hoping to find something that provides: > > 1. A Native BSON Data Type: Storing binary JSON natively inside Postgres > for faster processing. > > 2. MongoDB API/Query Compatibility: The ability to run Mongo-like > queries directly on top of Postgres tables. > > > > I am already aware of Foreign Data Wrappers like mongo_fdw, but that is > for querying a separate, external MongoDB instance. I want to keep the data > natively resident inside Postgres. > > > > Are there any active open-source extensions or projects that the > community recommends for this? (I have heard brief mentions of things like > pg_documentdb / FerretDB, but I'd like to get the community's perspective > on what is production-ready extension for it). > > > > This is a high quality project > https://github.com/documentdb/documentdb > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-05-21 05:56 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-05-20 12:26 Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension) Pratik Pandit <[email protected]> 2026-05-20 13:31 ` Jim Mlodgenski <[email protected]> 2026-05-21 05:56 ` Pratik Pandit <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox