DEV Community

Ajay g
Ajay g

Posted on

Difference b/w SQl and NoSQL

  1. In SQl We can use for Structured Data storage. means we need to define schema, table and columns before data insertion.
  2. In NOSQL no need to define any thing, we can store unstructured data.

Image description

Here i didn't defined column age in sql so i can't insert data age data. But in NOSQL i can insert that.

  1. RDBMS are suitable for applications that requires complex transactions, such as banking, finance and e-commerce.
  2. NoSql databases are designed to handle large volums of data with High-speed read and write operations, such as social media.
  3. Sql Databases we can scale Vertically(is based on the idea of adding more power(CPU and RAM) to existing systems.) and NoSQL Databases we can scale Horizantally(Adding New Servers). Vertical scalling is not only easy but also cheaper than Horizantal scaling. It also requires less time to be fixed.

Top comments (0)