SQL vs NoSQL

SQL (Structured Query Language) databases have been a primary data storage mechanism for more than four decades and open source options are such as MySQL, PostgreSQL and SQLite.

SQL vs NoSql



  • The model is of a relational nature
  • Data is stored in tables
  • Suitable for solutions where every record is of the same kind and possesses the same properties
  • Adding a new property means you have to alter the whole schema
  • The schema is very strict
  • ACID transactions are supported
  • Scales well vertically
  • Good for structured data.



NoSQL databases have existed since the 1960s, but have gaining attraction with popular options such as MongoDB,Redis, CouchDB and Apache Cassandra.NoSQL databases that enable storing unstructured and heterogeneous data at scale have gained in popularity.

  • The model is non-relational
  • May be stored as JSON, key-value, etc. (depending on type of NoSQL database)
  • Not every record has to be of the same nature, making it very flexible
  • Add new properties to data without disturbing anything
  • No schema requirements to adhere to
  • Support for ACID transactions can vary depending on which NoSQL DB is used
  • Consistency can vary
  • Scales well horizontally
  • Good for semi structured,complex or nested data.

SQL Database : 

  • MySQL Community Edition
  • MS-SQL Server Express Edition
  • Oracle Express Edition


NoSQL Database :

  • MongoDB
  • CouchDB
  • Redis


No comments:

Post a Comment

Download the eBook of react js for beginners

ReactJS basically is an open-source JavaScript library which is used for building user interfaces specifically for single page applications...

Popular