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
Use Supabase Auth and PostgreSQL row-level security for admin and employee access.
Validate Excel and CSV uploads in the browser before saving inventory records.
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