How can we design a system which can count Page Views per article , likes / dislikes like in Nomral video applications or social media websites.
What kind of Database is best suited , and other details on how to build such kind of system. How to count and store data (Page Views, Likes, dislikes) related to per article efficiently without effecting the main application operations.
Expecting 500-1000 real-time users . As this is not a enterprise product keeping cost low by using single instance for Database, Server and everything. Like a linux machine with 2Gb of RAM.
Hi Atul,
Thanks for the question! Here is how I would do it:
views,upvotesetc.P.S. I chose Mongo as I more comfortable with it. But feel free to go ahead and use an SQL DB like MySQL if you like. I don't think it will have major impact as you are anyway caching the upvotes/views and issuing a single update in specific intervals.
Hope this helps. Feel free to ask more questions.