4 ms·
I'd suggest to try the latest FoundationDB MongoDB layer. I would definitely do that if I had a use case.
by alexandre_m 8y ago
I'd suggest to try the latest FoundationDB MongoDB layer.
I would definitely do that if I had a use case.
- xellisx 8y agoDoes it offer relationships handling? That's the big downfall of MongoDB for me.
- christkv 8y agoMongo offers outer left joins through $lookup, now even with sub-queries. https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/#specify-multiple-join-conditions-with-lookup https://docs.mongodb.com/manual/reference/operator/aggregati... It also offers recursive left outer joins with $graphLookup.
- xellisx 8y agoI would have to take a look at that to see if resolves the issues I saw from back then.
- christkv 8y agoThere are no explicit foreign key relationships though if that is what you mean ?
- xellisx 8y agoI know there was a way to "link" records, but do to do anything with them, you had to pull all the data back into your app and manually filter and process records.
- christkv 8y agoThat's not been true for awhile. You use the aggregation framework with the $lookup stage to do an outer left join. db.employees.aggregate([{ $lookup: { from: "departments", localField: "departmentName", foreignField: "departmentName", as: "managers" } }]);
- christkv 8y agoYou can do nested joins as well. However deeply nested joins in MongoDB is probably an anti-pattern.