Let's work together!
Like my work and want something similar for your company? Sure, let's get to business!
App2Sales is a Brazilian company that allows users to create their own app without the need for a programmer. I was tasked with migrating an entire Firebase database to a Postgres database. The mobile app was fully integrated with Firebase, so transitioning to a relational schema required the use of an API, which was already in place (Node.js API) when I joined the project.
To achieve the migration goal, I had to create Shell and Python scripts to connect to Firebase's CLI, import data, convert it into a relational format, and insert it into the Postgres database. While the concept was straightforward, I encountered some minor challenges in practice. However, in the end, I successfully completed the migration. On the API level, I had to implement CRUD logic and define relations. After giving it some thought, I figured out how to transform the NoSQL data into a relational format for most tables.
The Product Manager of the application informed me that after the migration from Firebase to an API with a relational database, it saved them more than 90% of their monthly database costs. The expenses went from R$700 to just R$75, which greatly impressed me. I knew it would optimize costs, but it exceeded my expectations.
This was a fantastic experience, especially because I wasn't very familiar with Firebase at the time. It was a great opportunity for growth and learning.
Like my work and want something similar for your company? Sure, let's get to business!