Basic Overview:
Frontend: React JS
Backend: Node JS
Database: MySQL
Steps to run:
- install Node js, MySQL Workbench, MySQL Installer, create a new connection in MySQL Workbench with any connection name.
- git clone into your local file storage
- run the following commands in cmd terminal:
- cd backend && npm i
- cd ../frontend && npm i
- navigate to db_setup and run the two sql queries (data.sql and setup.sql in MySQL Workbench) to initialize your database.
- use "cd backend" in cmd and use "npm start" to start the backend server.
- use "cd frontend" in cmd and use "npm run dev" to run frontend (Vite + React).
- after inserting values see if values are successfully inserted into the table.
- NEW (22-Oct-2025) also install NODEMON into backend, it allows dynamic updation of server without restarting it.
- under package json in backend modify "start":"nodemon server.js"
- default pass for all emails is '123'.