DEV Community

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

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.