Back to Projects
Role
Full-Stack Engineer
Year
2025
Tech Stack
Next.jsPostgreSQLPrismaTypeScriptTailwind
The Problem
Environmental labs struggle with legacy software that lacks real-time collaboration and intuitive sample tracking. Data integrity issues and slow reporting cycles were common pain points.
The Solution
I architected a cloud-native LIMS using Next.js for the frontend and PostgreSQL for rigid data structure. The system enforces strict typing on sample data and provides real-time status updates for lab technicians.
Key Features
- Role-based access control (RBAC) for Admins vs Technicians
- Automated chain-of-custody tracking
- Dynamic reporting engine for client results
- Optimistic UI updates for high-volume data entry
Technical Challenges
Complex Data Relationships
Modeling the many-to-many relationships between Samples, Tests, and Clients required a carefully designed SQL schema to prevent query N+1 issues.
Audit Logging
Implemented a middleware-based logging system to track every mutation for compliance purposes without cluttering the business logic.