Why are we using sql database over nosql ?
- We dont need ACID properties here.
- We would need highly scalable DB and can choose between cassandra or mongodb . In my opinion we should go to cassandra because we need highly avaiable system( over consitency) and with cassandra we can easily store a key to list mapping as table.
Can someone explain the intuition behind using Mysql.
@Design_Gurus Can I ask you to please update these details with a detailed tradeoff when making a choice for the DB along with the reasoning since it is very important part of system designs( the DB ).