Elaborate on RDMBS vs NoSQL

[tomasvanrijsse]

it's not a 'versus' discussion, it's about what data to put in which db. Most (big) projects these days use both types of DB's in a single project

MySQL is useful for most of the data in all applications. Every application needs to start relational for example with entities like users, companies, subscription etc. Since most of the data we deal with is relational by nature.

NoSQL is useful for: ○ data collection without the time to properly normalize it in advance (e.g. collect log data and user activity without knowing what to do with it) ○ search engines (e.g. ElasticSearch) ○ for caching (you can put all data in a single document, skipping joins and allowing duplicate data)

To bad MongoDB has been hyped and in use for general purposes. This leads to skipping proper database design and will give trouble on schema changes

It's easy to simply store your JS objects as JSON in Mongo but thats just as easy in Postgress or MySQL.

Some comments from people wishing they never started using MongoDB: https://www.reddit.com/r/node/comments/8r263o/why_should_i_use_mongodb_and_not_mysql_with_node/#thing_t1_e0pfb21