Reasons for choosing Mysql storage over Firebase

Starting from a love letter from Google on Saturday, August 14, 2021, with details below, requires my attention to this issue. Based on this letter, my developer account will be closed because it has never been used, I have indeed registered for a Google Developer account for 25$ which is valid for life and have never published a single application, and the deadline is October 13, 2021.

After receiving this email, I was confused and tried to make a mobile application, the first application I created was to copy the cashflow application such as: https://github.com/TomasGB/CashFlow-React-Native-App But because this application uses Firebase as its storage, it requires me to modify it again using Mysql, there are 3 reasons why I don’t use Firebase storage

1. Firebase storage is not free/Free

Yes, Firebase storage is not free, for the amount of data less than 1 million records, Firebase is free and does not charge a fee, billing will start after our data amount is more than 1 million records, and fees will be charged based on data usage. Indeed the quota of 1 million records is quite large, and the application can run with Firebase for years, depending on the data usage of our application, but because I don’t want any additional costs after the application is sufficiently developed I prefer Mysql

2. Avoid changing the save format in the middle of the road

If at the beginning of an application project using Firebase, then after the application develops with large users, and knowing the costs / costs, it requires changing the storage format. This storage change can be problematic for many reasons: a lot of users, the data is very large, new bugs arise that must be resolved because there will be a lot of code changes in the application even the changes are estimated to be around 40-50% and will spend time repeating writing re-codes for the same application, it would be better if we have defined storage permanently without changes to application architecture, etc.

3. Firebase does not support SQL operations

The Firebase Realtime Database is a cloud-hosted NoSQL database that lets you store and sync data between your users in realtime. Based on the quote above, Firebase is a cloud storage with NoSQL database that can store and sync between users in realtime, but because the application I want requires various operations available in the database such as Select, Join, Where, relations between tables, and others. etc. These operations are not supported by Firebase. In addition, there are many more limits that you will encounter in development, for more details, you can check the firebase web documentation https://firebase.google.com/docs/firestore/quotas After finishing converting from Firebase to Mysql, finally on September 22, 2021, the application was finally published, the application which was originally called Personal Note was later renamed to Citizen Contribution, Cash Book & Arisan. Here is an example of the initial appearance of the application:

• 

• 

• 

• 

• 

•