MIME-Version: 1.0
References: 
 <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com>
 <CAB_5SRcZaQTCG9U5jPTJ6wkGbUe6S3UkhGCR2-a2QzN7Yyv2fg@mail.gmail.com>
In-Reply-To: 
 <CAB_5SRcZaQTCG9U5jPTJ6wkGbUe6S3UkhGCR2-a2QzN7Yyv2fg@mail.gmail.com>
From: Pratik Pandit <pratikpandit5322@gmail.com>
Date: Thu, 21 May 2026 11:26:38 +0530
Message-ID: 
 <CAFchsDXgL0PAiR8w+rSwBgbv32Fx04VvzU6-LvO9XqpvMbNXVQ@mail.gmail.com>
Subject: Re: Looking for a native MongoDB document extension for PostgreSQL
 (similar to pgvector like extension)
To: Jim Mlodgenski <jimmy76@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000006130d06524d94e1"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFchsDXgL0PAiR8w%2BrSwBgbv32Fx04VvzU6-LvO9XqpvMbNXVQ%40mail.gmail.com>
Precedence: bulk

--00000000000006130d06524d94e1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks, I'll check it out.

On Wed, May 20, 2026 at 7:01=E2=80=AFPM Jim Mlodgenski <jimmy76@gmail.com> =
wrote:

> On Wed, May 20, 2026 at 8:26=E2=80=AFAM 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 Postgre=
s
> 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 da=
ta
> 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 lik=
e
> 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
>

--00000000000006130d06524d94e1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks, I&#39;ll check it out.=C2=A0</div><br><div class=
=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr=
">On Wed, May 20, 2026 at 7:01=E2=80=AFPM Jim Mlodgenski &lt;<a href=3D"mai=
lto:jimmy76@gmail.com">jimmy76@gmail.com</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex">On Wed, May 20, 2026 at 8:26=E2=80=
=AFAM Pratik Pandit<br>
&lt;<a href=3D"mailto:pratikpandit5322@gmail.com" target=3D"_blank">pratikp=
andit5322@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; Hi everyone,<br>
&gt;<br>
&gt; I am looking to handle document-store workloads directly inside Postgr=
eSQL, but using MongoDB-style query patterns or optimized storage structure=
s.<br>
&gt;<br>
&gt; To give an analogy: I=C2=A0 highly appreciate how pgvector brings nati=
ve vector data types and specialized indexing (like HNSW) directly into Pos=
tgres, keeping everything inside the same database engine.<br>
&gt;<br>
&gt; I know Postgres has incredible jsonb capabilities natively, but I am l=
ooking for a PostgreSQL extension that bridges the gap closer to MongoDB. S=
pecifically, I&#39;m hoping to find something that provides:<br>
&gt; 1. A Native BSON Data Type: Storing binary JSON natively inside Postgr=
es for faster processing.<br>
&gt; 2. MongoDB API/Query Compatibility: The ability to run Mongo-like quer=
ies directly on top of Postgres tables.<br>
&gt;<br>
&gt; I am already aware of Foreign Data Wrappers like mongo_fdw, but that i=
s for querying a separate, external MongoDB instance. I want to keep the da=
ta natively resident inside Postgres.<br>
&gt;<br>
&gt; Are there any active open-source extensions or projects that the commu=
nity recommends for this? (I have heard brief mentions of things like pg_do=
cumentdb / FerretDB, but I&#39;d like to get the community&#39;s perspectiv=
e on what is production-ready extension for it).<br>
&gt;<br>
<br>
This is a high quality project<br>
<a href=3D"https://github.com/documentdb/documentdb" rel=3D"noreferrer" tar=
get=3D"_blank">https://github.com/documentdb/documentdb</a><br>
</blockquote></div>

--00000000000006130d06524d94e1--