System design: Build the John Hopkins COVID dashboard. How would you do it
Sigiloso
A service built with a pubsub on the back. Adding covid events would then update specific database tables. Different database tables for different aggregations of data and stats. Follow up question on how you can improve scaling by using a queue to write heavy system slowing down reads. Read replica on DB to allow for scaling