SQL vs NoSQL

Question

You are already familiar with SQL database. 

In the last several years, NoSQL database is getting widely adopted to solve various business problems.

What do you think which one is better?

Which one is better to use, better in terms of designing the architecture and good for getting o/p from a table?

Answer 1

According to what I know and have used I can differentiate SQL and NoSQL in the following ways:-

• Schema:- SQL databases have predefined schema whereas NoSQL databases have dynamic schema for unstructured data.

• Scalability:- SQL databases are vertically scalable whereas the NoSQL databases are horizontally scalable. SQL databases are scaled by increasing the horse-power of the hardware. NoSQL databases are scaled by increasing the databases servers in the pool of resources to reduce the load.

• Data Manipulation:- SQL databases uses SQL ( structured query language ) for defining and manipulating the data, which is very powerful. In NoSQL database, queries are focused on collection of documents. Sometimes it is also called as UnQL (Unstructured Query Language). The syntax of using UnQL varies from database to database.

• Examples:- SQL database examples: MySql, Oracle, Sqlite, Postgres and MS-SQL. NoSQL database examples: MongoDB, BigTable, Redis, RavenDb, Cassandra, Hbase, Neo4j and CouchDb

Answer 2

Well, it depends on what you are using it for. Both of these have their own pros and cons.