SQL vs NoSQL
| SQL | NoSQL |
|---|---|
| 1. Tables with fixed rows and columns | 1. JSON documents, key-value pairs, tables with rows and dynamic columns, nodes and edges |
| 2. Vertical Scaling (Scale-up with a larger sever) | 2. Horizontal Scaling (Scale-out across commodity servers) |
| 3. Strict Schema | 3. Dynamic Schema |
| 4. An ideal choice for the complex query intensive enviroment | 4. Not a good fit complex queries |
| 5. Oracle, MySQL, Microsoft SQL Server, and PostgreSQL | 5. MongoDB, DynamoDB, HBase, Neo4j |
| 6. Table-based | 6. Graph-Based, Document-Based, Key-Value Pair |
What you prefer? Comment down below ⬇️
NOTE: If you found this help. Like and share. Thanks, Happy Learning!
Let's connect 💜
You can follow me on Twitter, Instagram, LinkedIn & GitHub
Support Me
If you like this post. Kindly support me by Buying Me a Coffee
Oldest comments (0)