This question comes all the time. What makes you go for a nosql db and which one to choose ? There are so many - mongo, cassandra etc. How much of this is architecture driven ? Or you tend to use what the organisation has been using ? Kindly provide insights.
CAP theorem maybe.
Has ACID anything to do while selecting SQL db. Mostly Atomicity.
Cost of error. E.g. how much does it cost you to fix data error. Total cost, including damaged reputation etc.
I lean towards "NewSQL". I think it's more common to need a transaction or a join than it is to need the scaling advantages provided by the NoSQL DBs. The most important thing is to put DB access behind other interfaces.. Most of the SQL horror stories are giant monoliths with no architecture.
Thats a nice answer but I feel it should not be that simple. I believe there should be something more in NoSQL so people are moving towards it.
People were moving to it a few years ago when the state of SQL databases was really bad from a scaling and flexibility perspective. Now you have cloud native DBs like Spanner and Amazon RDS that solve a lot of these issues while still providing the features that made SQL the dominate standard for so long.
There's no right or wrong answer as companies like Uber and Netflix have proven to achieve scale with either technology. This means that for most cases, you will probably do well with either choice. What will be is important is understanding and acknowledging that both works, but what are the pros and cons of each DB and thus, which are more suitable. You can find out more at https://nodeflair.com/blog/sql-vs-nosql-databases-system-design-interview
Tech Industry
Yesterday
1846
What is the appeal to NVIDIA?
Software Engineering Career
Yesterday
2740
28 terrorist worshipping idiots just got themselves fired and I've never been prouder to work at Google.
2024 Presidential Election
Yesterday
1599
If you vote for Biden this year, don't complain about layoffs
Layoffs
Yesterday
10681
Google CFO confirms "large-scale" layoffs today (Apr 17)
Tech Industry
Yesterday
330
Amazon Internship or TikTok Fulltime?
NoSql if I know what to query during dev time, SQL if I don’t, e.g, olap report. Also, nosql has incentive to go for managed service like DDb.