Saturday, 17 December 2016


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

Featured post

How to create dynamic schema in mongodb

Sometime what we need in our application is to create mongodb schema for collection and some of our collection schema are same but names are...

Popular Posts