I have to create script in Python which like parameters has name of first collection and name of second collection ( MongoDB collections in db ). I need to perform JOIN between those two collections on some passed names of fields ( I don't know structure of collections and need to be generic enough ). I looked at ORMs like Ming, MongoKit, MongoAlchemy, MongoEngine and minimongo
http://api.mongodb.org/python/current/tools.html#orm-like-layers
Does anybody have experience with any of those ORMs and JOINS, any advice, example ?
Remon van Vliet :
It's very unlikely a MongoDB mapper/ORM solution would allow JOIN-like behaviour since it's a feature associated with relational databases and has no place in NoSQL based ORMs (for example, there's no way to do them consistently in MongoDB). Frankly, if the ORM does implement JOIN like behaviour for you I would probably consider it a design flaw.\n\nWhat's stopping you from implementing the requested functionality yourself in your py script?",
2012-03-20T10:12:30