SQL VS NOSQL

1. ) Sql called Relational databse vs Nosql called Non Relational or Distributed database.
2. ) Sql databases are table based databases vs Nosql databases can be document based,key value pairs,wide-column stores and graph databases etc.
3. ) Sql databases have predefined schema vs Nosql databases use dynamic schema for unstructured data.
4. ) Sql databases are vertically scalable which means that you can increase the load on a single server by increasing things like CPU, RAM or SSD vs Nosql databases are vertically scalable , means that you handle more traffic by sharding, or adding more servers in your NoSQL database..
5. ) Sql databases developed in the 1970s to deal with issues with flat file storage vs Nosql developed in the late 2000s to overcome issues and limitations of SQL databases.
6. ) Sql provides strong consistency vs Nosql depends on DBMS as some offers strong consistency like MongoDB, whereas others offer only eventual consistency, like Cassandra.
7. ) Sql follows ACID properties vs Nosql follows CAP(consistency, availability, partition tolerance).
8. ) Sql used in Banking,Accounting software's vs Nosql used in Amazon,You tube,Adobe,Facebook etc.
9. ) Sql databases are Oracle, MySQL, Microsoft SQL Server, and PostgreSQL vs Nosql databses are Document: MongoDB and CouchDB, Key-value: Redis and DynamoDB, Wide-column: Cassandra and HBase, Graph: Neo4j and Amazon Neptune.
10. ) Sql best suited for complex queries vs Nosql are not so good for complex queries.
11. ) Sql drawbacks- Horizontal scalability is not possible, Single point of failure vs Nosql drawbacks- No support of ACID transactions, CAP Theorem.

Thanks for reading !!

I’ll really appreciate some claps, if you find this blog useful :) Any suggestions are always welcome !!