Loading...
ChemUCL Inventory System
Full-Stack Developer
Technologies
Next.js 14Node.jsPostgreSQLPrismaAzureReactMaterial UIQR Code Integration
Overview
The ChemUCL project developed a dedicated chemical inventory management web application tailored specifically for the UCL Chemistry Department. The goal was to regain control over the inventory data previously hosted externally in Quartzy, improve the efficiency of chemical tracking and auditing processes, and implement QR code technology for easier management. ChemUCL was created to address critical issues such as high costs, data privacy, and inefficient item tracking. The application integrates QR code functionality for streamlined chemical auditing and location tracking, enhancing both usability and efficiency. The development involved comprehensive requirements gathering, system design, implementation, testing, and deployment stages. ChemUCL supports multiple user roles including Administrators, Staff, Temporary Staff, and Research Students, each with defined access levels and functionalities, particularly concerning the management and visibility of restricted chemicals. Key features include chemical inventory lists, location management, user and group administration, QR code scanning, and system logging for regulatory compliance reporting. The application was built using robust and scalable technologies ensuring performance, reliability, and maintainability.
Interactive Prototype
Key Technologies
Next.js 14 with React
Utilized Next.js 14 and React with Material UI to create an intuitive, responsive, and visually coherent user interface, improving overall user experience.
PostgreSQL with Prisma ORM
Implemented a robust relational database with Prisma for type-safe database access, effectively managing the extensive chemical inventory data with complex relationships.
QR Code Integration
Developed a flexible QR code system allowing codes to be linked dynamically with multiple types of data, such as chemicals and locations, enabling easy identification and tracking.
Azure Cloud Infrastructure
Deployed on Azure cloud services to ensure a secure and scalable hosting environment, facilitating smooth operation and reliable access to the inventory system.
Challenges & Solutions
Integration with Previous Dataset
Designed an effective migration strategy to import existing chemical data from Quartzy, ensuring data integrity and consistency when transitioning to the new system.
Data Schema for Multiuse of QR Codes
Implemented a flexible schema allowing QR codes to be linked dynamically with multiple types of data, such as chemicals and locations, creating a versatile tracking system.
Adapting to Existing Technician Workflows
Conducted extensive user consultation and iterative design cycles, ensuring that the application streamlined and enhanced existing workflows rather than disrupting them.
Performance Optimization
Implemented pagination, caching, and optimized queries to ensure fast performance despite the large dataset of 26,000+ chemicals across multiple laboratories.