This case study revolves around two clients seeking to modernize their Microsoft Access applications used primarily by government entities offering legal services. The Access application served as a single-tenant legal case management system for prosecutors and public defenders, tracking cases and attachments. However, as the databases grew, the application became prone to crashes, and its reliance on PC hosting led to issues with power interruptions, updates, and security concerns.
To address these challenges, a solution was developed to create a modern, multi-tenant, secure web application hosted on Heroku. This platform allows prosecutors and public defenders to access the system from anywhere, ensuring data security and eliminating power interruptions. The new interface provides ease of use and integrates with Google and Outlook calendars, while also allowing for unlimited attachments.
Technologies utilized include Ruby on Rails, Postgres SQL, and Heroku, enabling the transformation of the legal case management system into a reliable and efficient web-based solution.