DEV Community

Discussion on: Document vs Relational Databases

Collapse
 
cescquintero profile image
Francisco Quintero 🇨🇴

This is true:

Relational databases are very useful for situations where you might have a lot of data that intersects with each others

And also this:

Since you're just storing full on objects you'll have to pull them out of the database and into your application to get any specif data

plus the cost of duplication of data.

Your article reminds me of Sarah Mei's Why You Should Never Use MongoDB

She explains with more detail why MongoDB(I take it for many NoSQL) is not ideal once your app starts having relationships on its data. Which probably will always happen in any application.

The use case for NoSQL storages is for unorganized data but I think that specific use case firs better for features of a webapp rather than an app itself.

Collapse
 
tehbakey profile image
Blake Cooley

I don't think my post can hold up against Mei's article but I'm flattered it reminded you of it!

Honestly, based on my limited experience with both databases, I'd use MongoDB all the time if I could. If only because it's so much easier to pick up and understand than having to query and join tables. Raw mySQL queries can get really lengthy.

Sadly, the more complex my apps get as I learn I'm going to have to bite the bullet and embrace relational databases sooner or later.