SQL vs NoSQL

NoSQL Databases (or we can say "Not Only SQL") , were first introduced in late 2000s. NoSQL is a Non-Relational Database where we can store and retrieve data from it. In NoSQL databases, data is not stored in table (row & column) format rather it stores data in document format using JSON format ({Key : Value}). Lets read some major difference between SQL & NoSQL.

Here is an example of NoSQL data stored in JSON format. In this picture we can see unlike SQL here we have data in Key: Value pair. Every entry has a auto-generated unique "_id", each entry is known as a document & group of all those documents is known as collection.

When we should use NoSQL?

1. When we store & retrieve large amount of data.
2. When the relation between stored data is not important.
3. When data has no fixed schema & changing over time.
4. When Constraints & joins are not required (Complex Queries).

Give feedback in comments if you enjoyed reading it.

"Keep exploring to learn more, learning is the key to discover new world" - Harsh