One-to-Big Relationship: Getting Documents with One Request

Question

Returning to the classic mongodb example (messages and users):

Posts:

{title: "Greetings", body:"Hello world", userId:12345} 

Users

 {_id:12345, name:"John Smith", email: [e-mail] "} 

How to get a message

 {title: "Greetings", body:"Hello world", <username>:"John Smith"} 

with sigle request?

Answer 1

MongoDB is not an RDBMS - therefore NO CONNECTIONS - either you use two queries, or you use an attachment, or see "database links".