public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedLooking 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 <pratikpandit5322@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Pratik Pandit @ 2026-05-20 12:26 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 <jimmy76@gmail.com>
parent: Pratik Pandit <pratikpandit5322@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jim Mlodgenski @ 2026-05-20 13:31 UTC (permalink / raw)
To: Pratik Pandit <pratikpandit5322@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Wed, May 20, 2026 at 8:26 AM Pratik Pandit
<pratikpandit5322@gmail.com> 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 <pratikpandit5322@gmail.com>
parent: Jim Mlodgenski <jimmy76@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Pratik Pandit @ 2026-05-21 05:56 UTC (permalink / raw)
To: Jim Mlodgenski <jimmy76@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Thanks, I'll check it out.
On Wed, May 20, 2026 at 7:01 PM Jim Mlodgenski <jimmy76@gmail.com> wrote:
> On Wed, May 20, 2026 at 8:26 AM Pratik Pandit
> <pratikpandit5322@gmail.com> 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 <pratikpandit5322@gmail.com>
2026-05-20 13:31 ` Jim Mlodgenski <jimmy76@gmail.com>
2026-05-21 05:56 ` Pratik Pandit <pratikpandit5322@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox