I am seeking an experience-based comment on effectively storing thousands of likes and reactions that occur every second in a database. What database have you chosen, and if possible, answer why as well, along with schema/format!
We are currently using a custom key-value Go-based database, but now it's getting messy with growing numbers and is complex to manage.
How do apps like Discord maintain so many reactions for every post effectively and fetch them from the DB so effectively?
( User X liked Post Y with Reaction Z ) + ( User X liked Post Y with Reaction A ) + ( User B liked Post Y with Reaction C ) and so on..
Expectation:
- Fetch and return all reactions for the provided lists ( not paginated ), like 18,978 thumbs-up, 800 love, 1900 dislikes for every single item of the provided ID lists.
- Database can track the counting of total likes/reactions and can be fetched repeatedly for lists and specific items.
Thanks