Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


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" } }]);


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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: