DEV Community

Discussion on: Theory behind choosing either Relational or Non-Relational Database for your application

Collapse
 
alanmbarr profile image
Alan Barr

What would be real clear examples where I 100% need to use a SQL database versus NoSQL?

Collapse
 
olivermensahdev profile image
Oliver Mensah

Roughly I don't think there might be 100% use cases since the features make up the entire hundred 100%. Both are using 2/3 of that, which by the theory that is the maximum adoption.

Collapse
 
dobesv profile image
Dobes Vandermeer

You should be asking why you nee a nosql database instead. Consistency, atomicity, and transactions are very helpful in writing reliable applications. With nosql you generally have to handle multi document transactions yourself. They don't support aggregations over multiple collections/tables so reporting is a huge pain compared to SQL. SQL should be the default for most applications, unless they have a great motivation to use a nosql database.