when to use a relational database vs nosql code example

Example 1: 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.*/

Example 2: sql vs nosql

-----------------
key differences |
-----------------
SQL databases are usually RDBMS or DBMS
(Relational DataBase Management Systems) and are table based,
NoSQL uses unstructured data (like graphs)

-----------------
Examples        |
-----------------
SQL Databases:
MySQL
SQLite
Oracle DB

NoSQL:
MongoDB
DynamoDB

Tags:

Sql Example

Recent Posts