reading-notes

reading notes for code fellows

Project maintained by dLeigh01 Hosted on GitHub Pages — Theme by mattgraham

Mongo and Mongoose

High-level differences -

SQL databases are called RDBMS (relational databases) while NoSQL databases are called non-relational or distributed databases.
SQL databases are table based while NoSQL ar document based, key-value pairs, graph databases or wide-column stores.
SQL databases have predefined schema while NoSQL have dynamic structures.
SQL databases are vertically scaleable while NoSQL databases are horizontally scalable.
SQL databases use SQL (structured query language) while NoSQL databases focus queries on collections of documents.

The best data for a SQL database is a table.
A real world example of SQL data is a group of things all under one heading, like products.
The best data for a NoSQL database is key-value pairs.
A real world example of good NoSQL data is JSON.
NoSQL
SQL

SQL stands for Structured Query Language
A database that works in a specific way with SQL
it works with tables
the defined fields for the data
can store lots of data efficiently
uses collections rather than tables
documents in a similar form to JSON
MongoDB, you can change which data you’re getting as you go, and still have it in the same collection with no relations.
You can’t rely on your record having a specific field since it is schema-less.