Rango

Rango is a high-performance PHP library that reimplements the MongoDB PHP API on top of PostgreSQL using the power of JSONB.

It provides a drop-in compatible API, so you can use familiar MongoDB-style operations while storing your data in a reliable PostgreSQL database. This is ideal for applications that want PostgreSQL's ACID compliance and ecosystem without giving up the flexible document-based development experience of MongoDB.

Features

• Drop-in MongoDB API with Client, Database, and Collection
• CRUD operations like insertOne, find, updateMany, and deleteOne
• Rich query operators such as $gt, $in, $or, and $elemMatch
• Update operators like $set, $inc, $push, and $rename
• Projection and sorting with dot-notation support
• Aggregation pipelines with $match, $group, $unwind, and $lookup
• Bulk writes wrapped in a single transaction
• Index management backed by native PostgreSQL indexes

Installation

composer require patchlevel/rango

Rango needs the PDO extension and a PostgreSQL connection. The MongoDB extension is only required for the test suite, not at runtime.

Integration

• odm
• event-sourcing
• hydrator