MySQL Web Application Project

About

A small web application where the email address of the user is saved to the MySQL database. The database is updated real time and give the count of currently registered emails to the user.

Installations

• MySQL Workbench
• DataGrip (Not Necessary! You can still use the MySQL Workbench.)
• Node (v16 or greater)

Dependencies

npm install --save express
npm install faker
npm install mysql
npm install --save ejs
npm install --save body-parser

Usage

• Create a database in MySQL using schema.sql in sql-queries folder
• Change the username, password, database name in app.js file
• You can now run the app.js file and launch the app to view the live update of data
• The fakeDataTrigger.js is used to enter some dummy data into the database. This is just for illustration purpose for the web app. You can safely ignore this file.

node app.js

Acknowledgements

• Colt & Blue
• BG Image