DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’» is a community of 964,423 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
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

Top comments (0)

🌚 Friends don't let friends browse without dark mode.

Sorry, it's true.