Setup

Backend

• Open a terminal
• cd backend
• npm run dev

Frontend

• Open a terminal
• cd frontend
• npm start

When starting the backend for the first time, add {force: true} inside sequelize.sync() so that Sequelize automatically generates the tables

In .env file, the following variables need to be set

• PORT - Backend port
• USER - Required to access database (configure in SSMS)
• PASSWORD - Required to access database (configure in SSMS)
• SERVER - Name of server on which system is active (eg, "localhost")
• DATABASE - Name of the database
• DB_PORT - Port on which Database service is running (eg, 1433)
• JWT_SECRET - JWT Secret key (alphanumeric)
• COOKIE_EXPIRE

Place .env file in root folder inside backend

Stack

• ReactJS - Client
• Redux Toolkit + RTK Query - State Management and API
• Nodejs + ExpressJs - Server
• MS SQL Server - Database
• Sequelize - ORM

Demo