Partner with {keyword} or similar agencies in Europe and LATAM

Our goal was to create a unified application branch that could switch between two types of databases, which we deemed crucial for the maintenance process. Due to the incompatibility of certain tool functionalities, achieving a satisfactory result posed a significant challenge!


Approach

We chose the PostgreSQL management system mainly because it allows for easier maintenance of database schemas, and operations are less blocking, than MySQL.


Solution

Due to the fact that our client, mySugr, initially using MySQL, is part of the Roche group that utilizes the PostgreSQL system, we decided that standardizing the technological stack would be a key objective, which we achieved through migration.
We managed to reduce application maintenance costs by 50%. This result was accomplished by implementing the new version of Aurora.
Furthermore, we avoided a situation where we would be using unsupported components. If there were no attempts to migrate and adjust to Aurora 3 before 2024, AWS would not have been able to maintain the old system.


Outcome

A 9-month effort, starting from experiments and concepts, culminated in the creation of a compatible application. We employed a simplified version of the database switching process, which involves the alteration of an application parameter. The result? We successfully synchronized systems, delivering a product to the customer that aligns seamlessly with the vision of the Roche group, to which he has joined.


Business impact

Have you ever seen a Formula 1race or the Disney movie "Cars"? And were impressed by how fast they can change tires? We did something similar! But we like a challenge so we did it while the car was still on the race track in position. This "we" is actually a very small team of the most talented guys Ihave ever met.

***** *****

Backend Developer

Karl S.

Learn how fireup.pro worked with Enterprise/Corporation clients and how they can support your HealthTech product and team.

fireup.pro Success Story in HealthTech for Enterprise/Corporation - A case study | 2024

After introducing the Amazon Web Services database system's new version of Aurora 3 to the market, it became necessary to perform a heterogeneous migration for the mysugr application.
Due to technical reasons caused by the backtrack feature, the standard upgrade solution could not be used. As a result, the fireup.pro team had to select a tool that would allow them to start the migration process. Following a thorough analysis, the team opted for an open-source relational database management system with high availability - PostgresQL.


Problem

Heterogeneous migration for MySugr

fireup.pro

The overall synergy between our team and the client's company was outstanding, fostering a positive working relationship that significantly contributed to the project's success. It was a pleasure to be part of such a well-executed and impactful initiative.