Employee Tracker DB

Description

A NodeJS application making use of MySQL the npm Inquirer package to enable a simple command line interface by which a simple employee database can be queried and updated.

• Key features of the application are:
  • Use of inquirer for inputs
  • Use of mysql2 for interaction with a MySQL database

Table of Contents

• Usage
• Credits
• License

Installation

1. Install NodeJS if it is not already installed.
2. from the employee-tracker-db repository of GitHub:
   • select the green "<> Code" button
   • select the "Download ZIP" button from the resulting pop-up dialog
3. Placed the resulting employee-tracker-db-main.zip file in the location of your choice.
4. Unpack the employee-tracker-db-main.zip file, which should resulting in a folder/directory with name employee-tracker-db-main:
   • on Mac: double-click
   • on Windows: right-click and follow these instructions
5. Place the resulting files (except for this README.md and the screens/ folder and its contents) in a new directory.
6. Using bash, Mac terminal, or equivalent utility:
   • cd to the resulting employee-tracker-db-main directory
   • npm install (to install "mysql2" and "inquirer")

Usage

1. Navigate to the directory containing package.json and employeedb.mjs
2. enter either of:
   • npm start
   • node employeedb.mjs

A demonstration YouTube video can be found at https://youtu.be/pMeys1ryGHc .

Credits

Special thanks to the teaching staff of the University of Pennsylvania Full Stack Coding Boot Camp (UPENN-VIRT-FSF-FT-07-2023-U-LOLC-M-F).

• MDN Web Docs

License

As of this date (28 August 2023), the MIT license is applicable to this repository.