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 vote305 views1 answer
Mysql add fields
SQL
2 votes276 views2 answers
Oracle multiple insert
SQL
27 votes305 views5 answers
Add column in table
SQL
1 vote305 views1 answer
Psql connections
SQL
7 votes296 views6 answers
Group_concat mysql
SQL
0 vote297 views1 answer
To change the database owner in SQL server
SQL
1 vote252 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote302 views1 answer
Mysql sql.gz
SQL
1 vote294 views2 answers
Mysql show views
SQL
0 vote290 views1 answer
Connect postgresql using a connection string
SQL