For a Blog webapp, I am trying to model a set of users, blogs and actions on resources in mongo. Users can perform a no of actions such as 'like', 'star', 'feature' resources of a blog post such as 'blog posts' ,'links', 'images', etc.
The model will look like
User(user_id: long) Resource(resource_id: long) Resource/Action(int)
The first 16 bits are used to store actions and the next 15 for identifying what type of resource it is.
So given a query, - find the list of users who have liked an blog post.
What would be the best way to model and query this in mongo ?
I thought of something like
User(user_id: long) Resource(resource_id: long) Resource/Action(int)
2421423 4325235234 17
4223545 3454235432 18
4235234 4343453425 17
and using bitmask AND operations on the query parameters and the Resource/Action field to filter correct records. But looks like mongo does not support bitwise operations. I read $where javascript functions could be used for this purpose - but I am concerned about the performance of using js function calls for querying.
What would be a good way to achieve this use case ?
Thanks!