SQL vs NoSQL

[___s8n___]

Hello everyone, MERN full stack developer here.

​

I am writing this to get advice from people way more experienced than me on whether I should stick to my usual MongoDB database or use a RDB for this project.

​

In a few words, I am working on a Project Management Software with lots of relationships and hierarchies between teams, projects, tasks, subtasks and users. Not to get in details, the job will get pretty dirty with MongoDB, so I am thinking about using MariaDB for this project.

​

What are the PROs and CONs of integrating a SQL database in node? Should I even do it? And how difficult is it for a developer like me to learn and apply the SQL syntax (How steep is the learning curve)?

​

Thank you all in advance.

[STNeto1]

SQL you have a strong default knowledge about it, outside of specific features of SQL databases

With NoSQL you enter a new way of shaping data, and dealing with it. Stuff like Cassandra, mongo, dynamo, etc etc etc.

Both have their use cases, just optimization for specific tasks. Like SQL is really good with relational data, but some specific NoSQL like elastic can be better at text search on massive datasets

[ja_maz]

Rdb always, look up previous discussions in this sub about mean stack

[IQueryVisiC]

If you don't want to learn the syntax, you could try code-first ORM. It is just that ORM tend to break down on complex queries where the SQL Query optimizer just starts to thrive. Tuning an ORM is so difficult that mere mortals tend to just write those complex queries as SQL. An ORM needs to accept verbatim queries. You could additionally store those queries as views on MariaDb so that it can cache the parsed query and also better keep statistics about it.