SQL vs NoSQL: When to use?

Question

SQL vs NoSQL: When to use?

Answer 1

SQL is that standard query language used to deal with RDMS that is used to create, update, read, and delete records from a database. Here is a list of places where you can make use of SQL:

• When there is a communication requirement with any RDMS
• When you need to build custom reports and dashboards
• When you need to store and extract the data from the database
• When you need to make use of concepts like joins and execute complex queries

NoSQL is a Non-relational DBMS which does not require a fixed schema, and is extremely easy to use. Some of the places where you can make use of NoSQL are:

• When you do not require ACID support where ACID stands for Atomicity, Consistency, Isolation, and Durability
• When you cannot use SQL
• If your data requires a dynamic schema
• When you are logging data from multiple sources

To learn more about when you need to make use of SQL or NoSQL, you should watch this video tutorial: