DEV Community

Danish Saleem
Danish Saleem

Posted on

SQL vs NoSQL

SQL

  • Tables with fixed rows and columns
  • Vertical Scaling (Scale-up with a larger sever)
  • Strict Schema
  • An ideal choice for the complex query intensive enviroment
  • Oracle, MySQL, Microsoft SQL Server, and PostgreSQL

Table

NoSQL

  • JSON documents, key-value pairs, tables with rows and dynamic columns, nodes and edges
  • Horizontal Scaling (Scale-out across commodity servers)
  • Dynamic Schema
  • Not a good fit complex queries
  • MongoDB, DynamoDB, HBase, Neo4j

Graph-Based, Document-Based, Key-Value Pair

What you prefer? Comment down below


Let's connect!

You can follow me on Twitter, LinkedIn & GitHub


If you like this post. Kindly support me by Buying Me a Coffee

Buy Me a Coffee

Discussion (0)