DEV Community

NEYAZ NAFIZ
NEYAZ NAFIZ

Posted on

Difference between SQL and NoSQL databases.

SQL is a standard language for accessing and manipulating databases. NoSQL Database stands for a non-SQL database. NoSQL database doesn't use table to store the data like relational database.

SQL
SQL databases are relational,it use structured query language and have a predefined schema.SQL databases are vertically scalable, it's table-based databases, SQL databases are better for multi-row transactions.

NoSQL
NoSQL databases are non-relational.It's have dynamic schemas for unstructured data.It's a horizontally scalable databases. NoSQL databases are document, key-value, graph, or wide-column stores. NoSQL is better for unstructured data like documents or JSON.

Top comments (1)

Collapse
 
andrewbaisden profile image
Andrew Baisden

Which one is your first choice? Pretty sure a lot of JavaScript developers would say NoSQL because of the MERN, MEAN and MEVN technical stacks. I'm proficient with both of them though so I use whichever one I think would work best with the project.