Real-Time Inventory Management App

This project is a real-time inventory management web application built with FastAPI, PostgreSQL, and WebSockets. It allows users to add, update, and delete inventory items, with all changes instantly reflected across all connected clients.

Features

• Real-time updates: Inventory changes are broadcast to all clients using WebSockets.
• PostgreSQL triggers: Database-level triggers notify the backend of changes.
• Modern frontend: Simple, interactive UI with live status indicators.
• Dockerized: Easy to run locally with Docker and Docker Compose.

Tech Stack

• Backend: FastAPI (async), SQLAlchemy
• Database: PostgreSQL (with triggers and NOTIFY/LISTEN)
• Frontend: Vanilla JavaScript (served as static files)
• WebSockets: For real-time communication
• Docker: For containerized development

Getting Started

Prerequisites

• Docker
• Docker Compose

Quick Start

1. Clone the repository:

   git clone <your-repo-url>
   cd <your-project-directory>

2. Start the application:

   docker-compose up --build

3. Access the app:

   • Open your browser and go to http://localhost:8000