Steps to Integrate Database in Express JS
Step 1: Create an Express Application
Here we are going to create an express application because all of our work will be going to execute inside express. You can skip this step if you are comfortable with this stuff.
Write these commands in your terminal to start a node app and then install express. Make sure that you have successfully installed npm. The npm init will ask you for some configuration about your project and that is super easy to provide.
npm init
npm install express
Now create an empty .js file (let’s name it app.js), This would be our folder structure,
So, we are ready to start writing the express code inside this app.js file
//Importing express module
const express = require('express');
const app = express();
const PORT = 3000;
app.listen(PORT, (error) =>{
if(!error)
console.log("Server is Successfully Running, "
+ "and App is listening on port "+ PORT)
else
console.log("Error occurred, server can't start", error);
}
);
Note: Check out this link if you want to learn more about the initialization of the express applications.
Step 2: Run the server
in this step, we are going to confirm whether our server is working or not, Write this command in your terminal to start the express server. The successful start of the server denotes that our express app is ready to listen to the connection on the specified path(localhost:3000 in our example).
node app.js
Something like this will be shown to you in the terminal.
Step 3: Integrate Database
Here comes the most interesting part which you are searching for, Now we will integrate the database with express. But before that, we have to choose one of the database options i.e. MongoDB, MySQL, PostgreSQL, Redis, SQLite, and Cassandra, etc.
MongoDB and MySQL are the most popular and used by numerous developers, so we are going to discuss only these two. Also, they are totally different so you’ll get a chance to explore more, one is a Document-Oriented NoSQL Database, and the other is a Relational Model Database.
Note:- It is up to you whether you want to use a cloud database service or localhost, there exists only a slight difference. It is a good thing to know about how to access a cloud database, so here we are also going to discuss an example of cloud service.
Database Integration in Express.js
Express is a minimalistic framework that works along with Node.js and provides salient features to run a backend server and much more. As you know the database plays a vital role in a fully working application to persist data. In this article, we are going to discuss how we can integrate a database in a server that is working upon the Express.js framework.