Data Access in Node.js:
Node.js supports all kinds of databases no matter if it is a relational database or NoSQL database. However, NoSQL databases like MongoDb are the best fit with Node.js.
To access the database from Node.js, you first need to install drivers for the database you want to use.
The following table lists important relational databases and respective drivers.
| Relational Databases
|
Driver
|
NPM Command
|
| MS SQL Server
|
mssql
|
npm install mssql
|
| Oracle
|
oracledb
|
npm install oracledb
|
| MySQL
|
MySQL
|
npm install mysql
|
| PostgreSQL
|
pg
|
npm install pg
|
| SQLite
|
node-sqlite3
|
npm install node-sqlite
|
The following table lists important NoSQL databases and respective drives .
| NoSQL Databases
|
Driver
|
NPM Command
|
| MongoDB
|
mongodb
|
npm install mongodb
|
| Cassandra
|
cassandra-driver
|
npm install cassandra-driver
|
| LevelDB
|
leveldb
|
npm install level levelup leveldown
|
| RavenDB
|
ravendb
|
npm install ravendb
|
| Neo4j
|
neo4j
|
npm install neo4j
|
| Redis
|
redis
|
npm install redis
|
| CouchDB
|
nano
|
npm install nano
|
Note :
The above database list is not limited. There are many other databases and drivers available to be used with Node.js. Also, there are many drivers available for each database. So, choose a driver carefully based on your need.
Learn how to access MS SQL Server and MongoDB databases in the next section.
