public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Pratik Pandit <pratikpandit5322@gmail.com>
To: Jim Mlodgenski <jimmy76@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension)
Date: Thu, 21 May 2026 11:26:38 +0530
Message-ID: <CAFchsDXgL0PAiR8w+rSwBgbv32Fx04VvzU6-LvO9XqpvMbNXVQ@mail.gmail.com> (raw)
In-Reply-To: <CAB_5SRcZaQTCG9U5jPTJ6wkGbUe6S3UkhGCR2-a2QzN7Yyv2fg@mail.gmail.com>
References: <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com>
<CAB_5SRcZaQTCG9U5jPTJ6wkGbUe6S3UkhGCR2-a2QzN7Yyv2fg@mail.gmail.com>
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
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pratikpandit5322@gmail.com, jimmy76@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension)
In-Reply-To: <CAFchsDXgL0PAiR8w+rSwBgbv32Fx04VvzU6-LvO9XqpvMbNXVQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox