Reading-notes

five differences between SQL and NoSQL databases:

• SQL databases are primarily called as Relational Databases (RDBMS);
• NoSQL database are primarily called as non-relational or distributed database.

---

• QL databases are table based databases
• NoSQL databases are document based, key-value pairs, graph databases or wide-column stores.

---

• SQL databases have predefined schema
• NoSQL databases have dynamic schema for unstructured data.

---

• SQL databases are vertically scalable
• NoSQL databases are horizontally scalable.

---

• SQL databases uses SQL ( structured query language ) for defining and manipulating the data, which is very powerful.
• NoSQL database, queries are focused on collection of documents. Sometimes it is also called as UnQL (Unstructured Query Language). The syntax of using UnQL varies from database to database.

---

MySQL Community Edition

MySQL database is very popular open-source database. It is generally been stacked with apache and PHP, although it can be also stacked with nginx and server side javascripting using Node js.

---

MS-SQL Server Express Edition

It is a powerful and user friendly database which has good stability, reliability and scalability with support from Microsoft.

Oracle Express Edition

It is a limited edition of Oracle Enterprise Edition server with certain limitations. This database is free for development and deployment.

---

MongoDB

Mongodb is one of the most popular document based NoSQL database as it stores data in JSON like documents. It is non-relational database with dynamic schema. It has been developed by the founders of DoubleClick, written in C++ and is currently being used by some big companies like The New York Times, Craigslist, MTV Networks.

CouchDB

CouchDB is also a document based NoSQL database. It stores data in form of JSON documents.

Redis

Redis is another Open Source NoSQL database which is mainly used because of its lightening speed. It is written in ANSI C language.

---

Mongoose() Parameters options «Object» see Mongoose#set() docs Mongoose constructor.

The exports object of the mongoose module is an instance of this class. Most apps will only use this one instance.

Example: const mongoose = require('mongoose'); mongoose instanceof mongoose.Mongoose; // true

// Create a new Mongoose instance with its own connect(), set(), model(), etc. const m = new mongoose.Mongoose();