Skip to content
Hari.Back to projects

Case studyFull-Stack

Medicine Inventory System

Track stock, expiry dates, and dispensing.

Year
2026
Focus
Medicine inventory management

Overview

A React and Supabase medicine inventory app with admin and employee access, bulk uploads, dispensing, and analytics.

The challenge

Medicine inventory workflows need stock tracking, expiry checks, and different access rules for administrators and employees.

How it works

  1. Use Supabase Auth and PostgreSQL row-level security for admin and employee access.

  2. Validate Excel and CSV uploads in the browser before saving inventory records.

  3. Dispense through an atomic PostgreSQL function that rejects expired or unavailable stock, with analytics in React.

Technology stack

  • React
  • Vite
  • Supabase
  • PostgreSQL
  • Tailwind CSS
  • Recharts

Highlights

low-stock and expiry alerts
Inventory
Excel and CSV validation
Bulk upload
atomic stock updates
Dispensing

Let’s talk about this project.

Discuss this project