A command-line application built to manage a company's employee database using PostgreSQL. This tool allows users to view and manage departments, roles, and employees with ease.
Hi! I'm a full-stack developer with a passion for creating tools that simplify database management. This project was born from a desire to make handling employee data easier for businesses using SQL databases. With a background in technical problem-solving, I focus on developing applications that are both functional and user-friendly.
- View all departments, roles, and employees.
- Add new departments, roles, and employees.
- Update employee roles.
- Error handling for invalid department IDs and empty employee databases.
- Node.js (v18.20.4 or higher)
- PostgreSQL (v12+)
-
Clone the repository:
git clone https://github.com/GP-Person/EmployeeManager.git cd EmployeeManager
-
Install dependencies:
npm install
-
Setup PostgreSQL Database:
Ensure PostgreSQL is running on your system and create the database:
psql -U postgres https://drive.google.com/file/d/1VJa3idLguVrnanFWK_Dd7aH4lBeDe7ie/view