3 ms·
Strongly biased comment here, but hope its useful. Have you tried ToroDB (https://github.com/torodb/torodb https://github.com/torodb/torodb)? It still has a lo
by ahachete 10y ago
Strongly biased comment here, but hope its useful.
Have you tried ToroDB (https://github.com/torodb/torodb https://github.com/torodb/torodb)? It still has a lot of room for improvement, but it basically gives you what MongoDB does (even the same API at the wire level) while transforming data into a relational form. Completely automatically, no need to design the schema. It uses Postgres, but it is far better than JSONB alone, as it maps data to relational tables and offers a MongoDB-compatible API.
Needless to say, queries and cursors run under REPEATABLE READ isolation mode, which means that the problem stated by OP will never happen here. Problem solved.
Please give it a try and contribute to its development, even just with providing feedback.
P.S. ToroDB developer here :)
- nimrody 10y agoHow does ToroDB handles sharding across multiple instances?
- ahachete 10y agoRight now ToroDB handles sharding at the backend (RDBMS) level, with those dbs that support that. There's currently a Greenplum-based backend on the works, that obviously handles sharding by itself. Also CitusDB is on the roadmap. At a later release, we also plan to natively support MongoDB's sharding protocol.