Inventory Management System

An API built with Express and PostgreSQL for managing customers within an inventory system. This application allows you to create, read, update, and delete (CRUD) customer information.

Technologies Used

• Node.js
• Express.js
• PostgreSQL
• pg (node-postgres) for PostgreSQL connection
• dotenv for environment variable management

Getting Started

Prerequisites

Ensure you have the following installed on your machine:

• Node.js
• PostgreSQL

Installation

1. Clone the repository:

   git clone https://github.com/No-bodyq/Inventory-Management-System.git
   cd inventory-system

2. Install dependencies

   npm install

3. Setup the postgres database: Run the SQL commands in schema.sql

4. Configure environment variables Create a .env file in the project root directory with the following variables:

    DB_USER=your_db_user
    DB_HOST=localhost
    DB_NAME=your_db_name
    DB_PASS=your_db_password
    DB_PORT=5432
    PORT=3000

5. Running the Application

    npm start