SQL vs NoSQL

SQL vs NoSQL

SQL is a Structured Query Language for defining and manipulating data. It is used for storing and managing data in relational database management system(DBMS).NoSQL is known as non SQL or non relational database that provides a mechanism for storage and retrieval of data.

Differences between SQL vs NoSQL

  • SQL database is a Structured Query Language while NoSQL is an Unstructured Query Language.
  • SQL have a Table based database while NoSQL have a document based databases, key value stores, graph stores and wide column stores.

When to use SQL?

  • When we want to perform flexible queries

When to use NoSQL?

  • When the access pattern is defined

Advantages of SQL

  • High speed

Disadvantages of SQL

  • Process of interfacing is complex

Advantages of NoSQL

  • It is non relational. They vary from SQL databases therefore they provide the ease of management while ensuring a high level of flexibility with data models which are new.

Disadvantages of NoSQL

  • Community support is relatively less as its new.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store