Building a News-feed that comprises posts "created by user's connections" && "on the topics user is following"
- by aklin81
I am working on a project of Questions & Answers website that allows a user to follow questions on certain topics from his network.
A user's news-feed wall comprises of only those questions that have been posted by his connections and tagged on the topics that he is following(his expertise topics).
I am confused what database's datamodel would be most fitting for such an application. The project needs to consider the future provisions for scalability and high performance issues.
I have been looking at Cassandra and MySQL solutions as of now.
After my study of Cassandra I realized that Simple news-feed design that shows all the posts from network would be easy to design using Cassandra by executing fast writes to all followers of a user about the post from user.
But for my kind of application where there is an additional filter of 'followed topics', (ie, the user receives posts "created by his network" && "on topics user is following"), I could not convince myself with a good schema design in Cassandra. I hope if I missed something because of my short understanding of cassandra, perhaps, can you please help me out with your suggestions of how this news-feed could be implemented in Cassandra ?
Looking for a great project with Cassandra !
Edit: There are going to be maximum 5 tags allowed for tagging the question (ie, max 5 topics can be tagged on a question).