CODEWITHSUNDEEP
mysqlmongodbdatabasenosql
TIMEX
TIMEX

Reputation: 271794

In MongoDB, how do I query for something similar to Twitter?

Suppose I follow users 4, 7, 10, and 20. How can I query that in Mongo?

db.all_posts.find(users = 4, 7, 10, 20).sort( by date )

I don't know the right syntax. Is this scalable?

Upvotes: 0

Views: 324

Answers (1)

Niels van der Rest
Niels van der Rest

Reputation: 32184

Use the $in operator to match against multiple values:

db.all_posts.find({user: {$in: [4, 7, 10, 20]}}).sort({date: 1})

As you can see, the find(), sort() and most other methods in MongoDB take in objects as parameters. These objects are called query expression objects.

The question Making a Twitter-like timeline with MongoDB should answers your question about scalability, as it discusses the same data model as yours.

Upvotes: 1

Related Questions