{"id":1853,"date":"2022-07-05T15:28:03","date_gmt":"2022-07-05T08:28:03","guid":{"rendered":"https:\/\/www.bagi2info.com\/?p=1853"},"modified":"2023-01-04T12:07:47","modified_gmt":"2023-01-04T05:07:47","slug":"alasan-memilih-mysql-sebagai-penyimpanan-dibandingkan-firebase","status":"publish","type":"post","link":"https:\/\/www.bagi2info.com\/en\/reasons-for-choosing-mysql-storage-over-firebase\/","title":{"rendered":"Reasons for choosing Mysql storage over Firebase"},"content":{"rendered":"\r\n\r\nStarting from a love letter from <strong>Google<\/strong> 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 <strong>Google Developer<\/strong> account for <strong>25$<\/strong> which is valid for life and have never published a single application, and the deadline is <strong>October 13, 2021.<\/strong>\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2022\/07\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"623\" class=\"wp-image-1856\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2022\/07\/image.png\" alt=\"\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2022\/07\/image.png 946w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2022\/07\/image-300x198.png 300w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2022\/07\/image-768x506.png 768w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/a><\/figure>\r\n\r\n\r\n\r\n\r\nAfter 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:\r\n\r\n<a href=\"https:\/\/github.com\/TomasGB\/CashFlow-React-Native-App\">https:\/\/github.com\/TomasGB\/CashFlow-React-Native-App<\/a>\r\n\r\nBut because this application uses <strong>Firebase<\/strong> as its storage, it requires me to modify it again using <strong>Mysql<\/strong>, there are 3 reasons why I don&#8217;t use <strong>Firebase<\/strong> storage\r\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.bagi2info.com\/en\/reasons-for-choosing-mysql-storage-over-firebase\/#1_Firebase_storage_is_not_freeFree\" >1. Firebase storage is not free\/Free<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bagi2info.com\/en\/reasons-for-choosing-mysql-storage-over-firebase\/#2_Avoid_changing_the_save_format_in_the_middle_of_the_road\" >2. Avoid changing the save format in the middle of the road<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bagi2info.com\/en\/reasons-for-choosing-mysql-storage-over-firebase\/#3_Firebase_does_not_support_SQL_operations\" >3. Firebase does not support SQL operations<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Firebase_storage_is_not_freeFree\"><\/span>1. Firebase storage is not free\/Free<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\nYes, 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&#8217;t want any additional costs after the application is sufficiently developed I prefer <strong>Mysql<\/strong>\r\n<h2><span class=\"ez-toc-section\" id=\"2_Avoid_changing_the_save_format_in_the_middle_of_the_road\"><\/span>2. Avoid changing the save format in the middle of the road<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\nIf 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.\r\n<h2><span class=\"ez-toc-section\" id=\"3_Firebase_does_not_support_SQL_operations\"><\/span>3. Firebase does not support SQL operations<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\nThe Firebase Realtime Database is a cloud-hosted NoSQL database that lets you store and sync data between your users in realtime.\r\n\r\nBased on the quote above, Firebase is a cloud storage with <strong>NoSQL<\/strong> 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 <strong>Select, Join, Where<\/strong>, 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\r\n\r\nAfter finishing converting from Firebase to Mysql, finally on September 22, 2021, the application was finally published, the application which was originally called <strong>Personal Note<\/strong> was later renamed to <strong>Citizen Contribution, Cash Book &amp; Arisan.<\/strong>\r\n\r\nHere is an example of the initial appearance of the application:\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-gallery columns-3 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\r\n<ul class=\"blocks-gallery-grid\">\r\n \t<li class=\"blocks-gallery-item\">\r\n<figure><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252343132.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"1024\" class=\"wp-image-1331\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252343132-512x1024.jpg\" alt=\"\" data-id=\"1331\" data-full-url=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252343132.jpg\" data-link=\"https:\/\/www.bagi2info.com\/aplikasi-iuran-warga\/attachment\/1633252343132\/\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252343132-512x1024.jpg 512w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252343132-150x300.jpg 150w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252343132.jpg 720w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\r\n<\/li>\r\n \t<li class=\"blocks-gallery-item\">\r\n<figure><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313354.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"1024\" class=\"wp-image-1335\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313354-512x1024.jpg\" alt=\"\" data-id=\"1335\" data-full-url=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313354.jpg\" data-link=\"https:\/\/www.bagi2info.com\/aplikasi-iuran-warga\/attachment\/1633252313354\/\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313354-512x1024.jpg 512w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313354-150x300.jpg 150w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313354.jpg 720w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\r\n<\/li>\r\n \t<li class=\"blocks-gallery-item\">\r\n<figure><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313305.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"1024\" class=\"wp-image-1332\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313305-512x1024.jpg\" alt=\"\" data-id=\"1332\" data-full-url=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313305.jpg\" data-link=\"https:\/\/www.bagi2info.com\/aplikasi-iuran-warga\/attachment\/1633252313305\/\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313305-512x1024.jpg 512w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313305-150x300.jpg 150w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313305.jpg 720w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\r\n<\/li>\r\n \t<li class=\"blocks-gallery-item\">\r\n<figure><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313322.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"1024\" class=\"wp-image-1333\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313322-512x1024.jpg\" alt=\"\" data-id=\"1333\" data-full-url=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313322.jpg\" data-link=\"https:\/\/www.bagi2info.com\/aplikasi-iuran-warga\/attachment\/1633252313322\/\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313322-512x1024.jpg 512w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313322-150x300.jpg 150w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313322.jpg 720w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\r\n<\/li>\r\n \t<li class=\"blocks-gallery-item\">\r\n<figure><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313338.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"1024\" class=\"wp-image-1334\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313338-512x1024.jpg\" alt=\"\" data-id=\"1334\" data-full-url=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313338.jpg\" data-link=\"https:\/\/www.bagi2info.com\/aplikasi-iuran-warga\/attachment\/1633252313338\/\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313338-512x1024.jpg 512w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313338-150x300.jpg 150w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/1633252313338.jpg 720w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\r\n<\/li>\r\n \t<li class=\"blocks-gallery-item\">\r\n<figure><a href=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/Screenshot_2021-10-05-05-55-36-766_com.suryadi.personalnote.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"1024\" class=\"wp-image-1330\" src=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/Screenshot_2021-10-05-05-55-36-766_com.suryadi.personalnote-512x1024.jpg\" alt=\"roda keberuntungan\" data-id=\"1330\" data-full-url=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/Screenshot_2021-10-05-05-55-36-766_com.suryadi.personalnote.jpg\" data-link=\"https:\/\/www.bagi2info.com\/aplikasi-iuran-warga\/screenshot_2021-10-05-05-55-36-766_com-suryadi-personalnote\/\" srcset=\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/Screenshot_2021-10-05-05-55-36-766_com.suryadi.personalnote-512x1024.jpg 512w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/Screenshot_2021-10-05-05-55-36-766_com.suryadi.personalnote-150x300.jpg 150w, https:\/\/www.bagi2info.com\/wp-content\/uploads\/2021\/10\/Screenshot_2021-10-05-05-55-36-766_com.suryadi.personalnote.jpg 720w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/figure>\r\n<\/li>\r\n<\/ul>\r\n<\/figure>\r\n\r\n\r\n\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>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&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":1880,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,173],"tags":[197,63,82],"class_list":["post-1853","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-komputer","category-react-native","tag-firebase","tag-iuran-warga","tag-mysql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts\/1853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/comments?post=1853"}],"version-history":[{"count":3,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts\/1853\/revisions"}],"predecessor-version":[{"id":3637,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts\/1853\/revisions\/3637"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/media\/1880"}],"wp:attachment":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/media?parent=1853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/categories?post=1853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/tags?post=1853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}