Note: Code is unavailable for view due to signed NDA
This was a 12-week industry sponsored project partnered with my school. This project was completed in a team of 5 developers. Our client wanted to digitize their manual method of inputting and managing client data. Their previous system involved using Excel spreadsheets to store records. Our team designed a webapp that allowed lab technicians login/signup and input data through a front-end, storing records into a database. Users could also edit past records and visualize aggregate data.
- Designed and implemented relational database solution to store client data and handle queries on the back-end
- Used Figma to design mockups for client approval
- Integrated front-end forms to work with database and backend
- Created authentication features for secure login/signup
- Hosted on AWS for client demo usage
- Applied Agile workflow for continuous updates/deliverables
- Currently our Database is within docker which is not ideal. In the case that docker goes down, our database could be lost or currupted. In that case, the database should be hosted on AWS using RDS or Aurora. Alternatively, the client could internally host their database on a local server.
- Database migration script is ran everytime the application spins up which is not best practice. Future iterations should look to libraries such as knex for better migration services.