On: MongoDB removed from RHEL 8 beta due to license

[alexandre_m]

I'd suggest to try the latest FoundationDB MongoDB layer.

I would definitely do that if I had a use case.

[xellisx → alexandre_m]

Does it offer relationships handling? That's the big downfall of MongoDB for me.

[christkv → xellisx]

Mongo offers outer left joins through $lookup, now even with sub-queries.

https://docs.mongodb.com/manual/reference/operator/aggregati...

It also offers recursive left outer joins with $graphLookup.

[xellisx → christkv]

I would have to take a look at that to see if resolves the issues I saw from back then.

[christkv → xellisx]

There are no explicit foreign key relationships though if that is what you mean ?

[xellisx → christkv]

I 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 → xellisx]

That'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 → christkv]

You can do nested joins as well. However deeply nested joins in MongoDB is probably an anti-pattern.