DEV Community 👩‍💻👨‍💻

Discussion on: What database should I use?

sarneeh profile image
Jakub Sarnowski

Mostly, with NoSQL you can't assure any kind of data integrity - everything needs to be based on your app's code. There are no relationships in NoSQL unless you code it yourself - I think that's the main pain for me and it's very, very fragile.

Thread Thread
patarapolw profile image
Pacharapol Withayasakpunt

Indeed, most RDBMS enforces integrity very well, and it would be counter-intuitive to store denormalized / JSON data. Actually, graph-type NoSQL can do this as well (as well as being ACID compliant).

BTW, how do you balance between ORM features vs true SQL features?