Mongo and Mongoose
| SQL |
NoSQL |
| Databases called relational Databases (RDBMS) |
Databases called non-rational or distributed databases |
| Table based databases |
Document based, key-value pairs, graph databases |
| have predefined schema |
dynamic schema |
| vertically scalable |
horizontally scalable |
| uses structured query lang for finding chanigng data |
queries focused on collection of docs |
- What kind of data is a good fit for an SQL database?
- complex query intensive enviroment
- Give a real world example.
- MySql, oracle, Sqlite, Postgres and MS-SQL
- What kind of data is a good fit a NoSQL database?
- hierarchical data. High data set
- Give a real world example.
- MongoDB, BigTable, Redis, RavenDb, Cassandra, Hbase, Neo4j and CouchDb
- Which type of database is best for hierarchical data storage?
- Which type of database is best for scalability?
- well SQl is vertically scaleble. Can manage on single server.
- NoSQL is horrizontal and can just add few more servers easily to handle large traffic
# cite
- SQL vs NoSQL Database Differences Explained with few Example DB (https://www.thegeekstuff.com/2014/01/sql-vs-nosql-db/?utm_source=tuicool)