DEV Community

Discussion on: When to use NoSQL over SQL ?

Collapse
 
sanchit170054 profile image
Maverick

Yeah am agree with Brandin Chiu. RDBS are not designed to handle changes. Today, change occurs frequently, and data modeling is a huge challenge because of the time and resources that relational databases require. Unfortunately, when using a relational database, even a simple change like adding or replacing a column in a table might be a million dollar task. RDBMS can not handle 'Data Variety'. The amount of , Whereas in Cassandra (a NoSQL database), you can add a column to specific row partitions. For every change you make, you should ensure strict ACID properties.

Thread Thread
 
brandinchiu profile image
Brandin Chiu

To be clear: I'm referring to schema changes being tricky in nosql solutions, not relational systems.