I am working on a project of Questions & Answers website that allows a user to follow questions on certain topics from his network.
I want to build user's news-feed wall that comprises of only those questions that have been posted by his connections and tagged on the topics that he is following(his expertise topics). 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 schema/ how this news-feed could be implemented in Cassandra ? Many thanks !
