Sql vs nosql

Nosql vs sql

A SQL Database follows a table like structure which can have an 
unlimited number of rows and every data present inside the database 
is properly structured with Predefined Schemas, it is basically used 
to manipulate Relational Databases Management Systems.

A NoSQL Database is a Distributed Database where the data is very 
unstructured with Dynamic Schema. Unlike SQL it cannot have unlimited 
rows but it follows a Standard Schema Definition and can store all 
sorts of data models with large distributed data in the form of 
key-value pairs, graph databases, documents or wide-column stores.

Source: hackernoon.com

Sql vs nosql

/* KEY DIFFERENCE
SQL pronounced as "S-Q-L" or as "See-Quel" is primarily called RDBMS or Relational Databases whereas NoSQL is a Non-relational or Distributed Database.
SQL databases are table based databases whereas NoSQL databases can be document based, key-value pairs, graph databases.
SQL databases are vertically scalable while NoSQL databases are horizontally scalable.
SQL databases have a predefined schema whereas NoSQL databases use dynamic schema for unstructured data.
SQL requires specialized DB hardware for better performance while NoSQL uses commodity hardware.*/

Similar codes

1 vote340 views2 answers
Check if word is in column sql
SQL
5 votes372 views4 answers
Start postgres server
SQL
3 votes393 views6 answers
DB::table('users')->get();
SQL
15 votes337 views2 answers
Sql order by multiple columns
SQL
0 vote346 views2 answers
How to create a table from another table in sql derby
SQL
0 vote356 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
-1 vote342 views1 answer
Su: Authentication failure mysql
SQL
0 vote357 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote347 views1 answer
Select from column mysql
SQL
0 vote365 views1 answer
Oracle locked objects
SQL