SQL vs NoSQL

Structured Query language (SQL) is the standard language for dealing with Relational Databases

NoSQL is a non-relational DMS, that does not require a fixed schema, avoids joins, and is easy to scale. NoSQL database is used for distributed data stores with humongous data storage needs. NoSQL is used for Big data and real-time web apps. For example companies like Twitter, Facebook, Google that collect terabytes of user data every single day.

SQL databases are table based databases whereas NoSQL databases can be document based, key-value pairs, graph databases, whereas NoSQL databases can be document based, key-value pairs, graph databases.

SQL requires specialized DB hardware for better performance while NoSQL uses commodity hardware.

PS : “This was a blog entry using an article from guru99”.