Pongo - Mongo but on Postgres and with strong consistency benefits.
Install Pongo as an npm module and save it to your package.json:
npm install @event-driven-io/pongoRead also introduction article on my blog for more context.
You can use Pongo syntax with explicit typing about supported syntax:
import { pongoClient } from "@event-driven-io/pongo";
import { v4 as uuid } from "uuid";
type User = { name: string; age: number };
const connectionString =
"postgresql://dbuser:[email protected]:3211/mydb";
const pongoClient = pongoClient(postgresConnectionString);
const pongoDb = pongoClient.db();
const users = pongoDb.collection<User>("users");
const roger = { name: "Roger", age: 30 };
const anita = { name: "Anita", age: 25 };
const cruella = { _id: uuid(), name: "Cruella", age: 40 };
// Inserting
await pongoCollection.insertOne(roger);
await pongoCollection.insertOne(cruella);
const { insertedId } = await pongoCollection.insertOne(alice);
const anitaId = insertedId;
// Updating
await users.updateOne({ _id: anitaId }, { $set: { age: 31 } });
// Deleting
await pongoCollection.deleteOne({ _id: cruella._id });
// Finding by Id
const anitaFromDb = await pongoCollection.findOne({ _id: anitaId });
// Finding more
const users = await pongoCollection.find({ age: { $lt: 40 } });Or use MongoDB compliant shim:
import { MongoClient } from "@event-driven-io/pongo";
import { v4 as uuid } from "uuid";
type User = { name: string; age: number };
const connectionString =
"postgresql://dbuser:[email protected]:3211/mydb";
const pongoClient = new MongoClient(postgresConnectionString);
const pongoDb = pongoClient.db();
const users = pongoDb.collection<User>("users");
const roger = { name: "Roger", age: 30 };
const anita = { name: "Anita", age: 25 };
const cruella = { _id: uuid(), name: "Cruella", age: 40 };
// Inserting
await pongoCollection.insertOne(roger);
await pongoCollection.insertOne(cruella);
const { insertedId } = await pongoCollection.insertOne(alice);
const anitaId = insertedId;
// Updating
await users.updateOne({ _id: anitaId }, { $set: { age: 31 } });
// Deleting
await pongoCollection.deleteOne({ _id: cruella._id });
// Finding by Id
const anitaFromDb = await pongoCollection.findOne({ _id: anitaId });
// Finding more
const users = await pongoCollection.find({ age: { $lt: 40 } }).toArray();Pongo treats PostgreSQL as a Document Database benefiting from JSONB support. Unlike the plain text storage of the traditional JSON type, JSONB stores JSON data in a binary format. This simple change brings significant advantages in terms of performance and storage efficiency.
Pongo uses the following table structure for storing collections:
CREATE TABLE IF NOT EXISTS "YourCollectionName" (
_id UUID PRIMARY KEY,
data JSONB
)The binary format of JSONB means that data is pre-parsed, allowing faster read and write operations than text-based JSON. You don't have to re-parse the data every time you query it, which saves processing time and improves overall performance. Additionally, JSONB supports advanced indexing options like GIN and GiST indexes, making searches within JSONB documents much quicker and more efficient.
Moreover, JSONB retains the flexibility of storing semi-structured data while allowing you to use PostgreSQL's robust querying capabilities. You can perform complex queries, joins, and transactions with JSONB data, just as you can with regular relational data.
Contrary to common belief, JSON document data is structured. JSON has structure, but it is not enforced for each document. We can easily extend the schema for our documents, even for specific ones, by adding new fields. We should also not fail if the field we expect to exist, but doesn't.
This flexibility, performance, and consistency combination makes PostgreSQL with JSONB a powerful tool. There are benchmarks showing that it can be even faster than MongoDB.
Pongo is a similar concept to Marten and AWS DocumentDB (see here or there, they seem to be using Mongo syntactic sugar on top of AuroraDB with Postgres).
Check more in:
- JSON Types Documentation
- JSON Functions and Operators
- PostgreSQL, JSONB and GIN Indexes by
- MongoDB vs PostgreSQL JSONB Benchmark
- How to JSON in PostgreSQL
What's there it's safe to use, but it's far from being 100% compliant with MongoDB.