Simpe queries, no transactional capability and Availability over consistency -> NoSql (Scale or no Scale)
Interview Experience
Hi everyone, I have been preparing for system design interviews and been in pipeline for few compaines. While studying about it, I see a total of 4 parameters for any system design question out there
Full Details
Hi everyone, I have been preparing for system design interviews and been in pipeline for few compaines. While studying about it, I see a total of 4 parameters for any system design question out there * Query Patterns * Transactional Gurantees * CAP * Schema design I have seen people choosing NoSql left and right citing one reason which is Scale, but i think scale comes much later in this decision making. By the time scale comes into considerstion the above 4 should give a pretty good idea on best database to choose. Scale usually doesn’t decide early, but at an extreme levels it can override other considerations. But in an interview, if you say SQL for designing a Review System, god help you xD