Pongo is a powerful tool that uses PostgreSQL as a Document Database with JSONB support for faster read and write operations. JSONB’s binary format improves performance and storage efficiency, offering advanced indexing options like GIN and GiST for quicker searches. Contrary to common belief, JSON document data is structured and flexible, allowing easy schema extensions and specific field additions. PostgreSQL with JSONB can outperform MongoDB in benchmarks. While Pongo is production-ready, it’s not fully compliant with MongoDB. It’s a concept similar to Marten and AWS DocumentDB, offering strong consistency benefits when used with Postgres. Check out relevant JSON Types, Functions, and Indexes documentation for more information.
https://github.com/event-driven-io/Pongo