NoSQL stands for Non-relational or distributed database system. |
SQL stands for RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS) |
NoSQL databases have dynamic schema |
SQL databases have a static or fixed or predefined schema |
NoSQL databases are ideal for hierarchical data storage. |
SQL databases are not ideal for hierarchical data storage. |
NoSQL databases are not so decent for complex queries |
SQL databases are ideal for complex queries |
NoSQL databases are Horizontally scalable. |
SQL databases are Vertically Scalable. |
NoSQL database Follows consistency, availability, and partition tolerance. |
SQL database follows atomicity, consistency, isolation, and durability. |
Examples of NoSQL databases: MongoDB, GraphQL, HBase, Neo4j, Cassandra, etc |
Examples of SQL databases: MySQL, PostgreSQL, Oracle, MS-SQL Server, etc |