Back
Year
2026
Tech & Technique
React, Firebase, Firestore, WebSockets, Tailwind CSS, TypeScript
Description
Problem: The college campus vegetable store lacked an efficient way to manage daily stock and process orders for over 300 faculty members, relying on manual billing and causing stock overselling issues.
Solution: Built Engal Sandhai, a web-based, intranet-only billing and realtime stock management system connecting 300+ daily active faculty buyers with admin staff. The platform streamlines orders, handles static QR-based payments, and perfectly syncs inventory.
Key Features:
Technical Implementation:
Impact: Currently in active production use by 300+ college staff members daily, completely digitizing the campus vegetable store's billing and inventory workflow.
Solution: Built Engal Sandhai, a web-based, intranet-only billing and realtime stock management system connecting 300+ daily active faculty buyers with admin staff. The platform streamlines orders, handles static QR-based payments, and perfectly syncs inventory.
Key Features:
- ⚡ Realtime Updates: Instant stock sync and live new-order notifications across all connected clients via WebSockets.
- 🧮 Atomic Transactions: Multi-item order processing with atomic stock decrements to completely prevent race conditions and overselling.
- 🔐 Role-Based Auth: Employee ID-based authentication with forced password resets and strict per-order session rules (auto-logout after payment upload).
- 🛍️ Purchasing & Billing: Comprehensive buying panel with cart management, automated bill generation, and payment screenshot uploads.
- 🛠️ Admin Dashboard: Full control over daily stock updates, price management, manual payment verification, and order reverting.
Technical Implementation:
- Architected a highly responsive real-time backend using Firebase Authentication and Firestore database.
- Implemented WebSockets for live stock synchronization and instant admin notifications.
- Ensured data integrity during high-concurrency periods using atomic Firestore transactions.
- Deployed as a lightweight, intranet-only self-hosted stack eliminating the need for paid cloud infrastructure.
Impact: Currently in active production use by 300+ college staff members daily, completely digitizing the campus vegetable store's billing and inventory workflow.
My Role
Backend Developer & Deployment Engineer
Led the backend architecture and production deployment:
Led the backend architecture and production deployment:
- 🗄️ Database Architecture: Designed the Firestore schema for users, orders, and real-time stock tracking.
- ⚡ Atomic Transactions: Engineered the critical order-processing logic using Firestore atomic transactions to prevent overselling during peak purchase times.
- 📡 Realtime Infrastructure: Integrated WebSockets and Firestore listeners for instant state synchronization across 300+ concurrent clients.
- 🔐 Security & Auth: Configured Firebase Auth and security rules for strict role-based access control between Admin faculty and standard users.
- 🚀 Deployment: Configured and deployed the entire system on a local intranet-only environment for zero-cost, high-speed operation.
