Management App to the Cloud
Overview
Challenge: Migrate the MS Access management app of a knowledge company to a modern cloud infrastructure
Solution: Built a scalable, performant backend on Quarkus with a stylish, convenient frontend in React, transitioning over 15 years worth of accumulated business processes, VBA code and data in 9 months
Technologies: Quarkus, Java 17, React, Postgres, AWS (EC2, CF, CodeCommit, S3)
One App to Rule Them All
The best applications are the ones that are directly tailored to the needs of the organisation. Not all companies invest the time and energy to develop fully customised apps for their own operational needs, but those that do gain a considerable advantage: it's not them, who need to adapt to the technology, it's technology that adapts to them.
My client has invested into their own application from the getgo over 15 years ago and built a highly customised application in Microsoft Access. The app covered every aspect of the company's operations: projects, tasks, financials, billing, expenses, reporting, asset and computing system mangement - a very comprehesive set of capabilities.
Team Member, with Quirks
This application is part of their team. It does what the team needs and the team knows the quirks... Because as the platform ages and the application grows, limitations do appear.
In particular, remote working makes an Access-based solution really cumbersome and significantly increases the operational complexity and costs.
That was the impetus for moving the application to the cloud, to a modern platform that can cope with the current needs and will be able to adapt to the evolving technology landscape.
Enterprise Service
The app is the nervous system that connects the staff members helping them with daily tasks. It is used all the time from associates to CEO. And carries the highly valuable project and task information about the operations of the company, so the target platform must be secure, reliable and fast.
The solution takes advantage of AWS services for storage, compute and security. It is built on Quarkus, the highly performant Java platform providing enterprise level robustness and scalability.
The user experience has been elevated from the beige background Access forms to a modern, visually pleasing and easy-to-use React-based single page application integrated with the backend.
The easy platform for running projects of any size.
To discuss tailored projects, please connect on LinkedIn.