Red Cat Data had an existing web application written many years ago for managing a private internal database of products. This needed to be updated to work with the latest version of PHP, as well as fixing outstanding security issues.
After an analysis of the code, it was decided that a more cost-effective long-term solution was to build a new system and migrate the data across. This was also an opportunity to build on a modern framework (Slim) and make some feature improvements. Changes included:
- Upgrade from PHP 5.6 to 8.3
- Seamless migration of over 70,000 products
- CSS framework (Bulma) for a responsive design with minimal code
- Foreign keys for referential integrity
- Multi-factor authentication to protect accounts
- Code moved into version control
- Automatic deployments
In addition to the above, I setup a staging site for testing new features, as well as a Docker configuration for local development.