Game Inventory manager with Express JS and PostgreSQL

📦 Getting Started

Follow these steps to run the project locally.

1️⃣ Clone the repository

git clone https://github.com/iamzehan/Project-Inventory-Mgt.git

2️⃣ Install dependencies

npm install

3️⃣ Run the development server

npm run dev

4️⃣ Open in browser

http://localhost:3000

5️⃣ Populate Database

node ./src/models/populatedb

6️⃣ Create Super User (v2.0.0 update)

node ./src/models/createUser

7️⃣ Create session table for session persist (v2.0.0 update)

node ./src/models/session

---

🗂 Project Structure

Express-APP-template/
├── src
    ├── auth/               # Passport auth handler
    ├── controllers/        # Request handlers (business logic)
    ├── models/             # Database logic
    ├── routes/             # Application routes
    ├── views/              # EJS templates
    ├── public/             # Static assets (CSS, JS, images)
    ├── app.js              # App entry point
├── package.json
├── .env.example        # Environment variables example
└── README.md

---

⚙️ Available Scripts

Command	Description
npm run dev	Starts development server with live reload
npm start	Starts production server

---

🔐 Environment Variables

Create a .env file in the root directory:

PORT=3000
DATABASE_URL=postgresql://user:password@localhost:5432/dbname

Refer to .env.example for required variables.

---

🎯 Use Cases

• CREATE, UPDATE, DELETE, READ
  • Games, Genres, Developers
• Dashboard View Information

---

Log in Form (v2.0.0 feature)

Dashboard (version 2.0.0 shows logged in user)

Games Inventory Data View

Developers Inventory Data view

Genre Data View

Game Edit Form

Game Add Form

Add New Genre Form

Edit Genre Form

Delete View

Confirmation Popup Modals

Add

Update

Dark mode (v2.1.0)

⭐ Support

If this repository helped you, consider giving the repo a ⭐ on GitHub — it really helps!