connect MySQL with Firebase

Question

Currently I am creating a dashboard website by using MySQL as my database. Now, I need to get some data from Firebase which connected to my Android app. Anyone has any ideas on how to doing this kind of stuffs?

It seems like not much of this solution shown up after surfing through Internet.

score 0 · Answer 1 · answered Feb 22 '18 at 08:24

0

First, keep in mind that Firebase uses NoSQL database technology. So you can't create tables and fields in Firebase at self. But you could make a workaround which fetches the data from Firebase and processing by a script on your web server and runs an SQL command to your MySQL database.

The technical part can be the language of your choice. Usually, in combination with MySQL, you use PHP. Here are an SDK and documentation about how to implement it in that language.

From this SDK you could now fetch data from Firebase and store it via an SQL command to your MySQL database.

answered Feb 22 '18 at 08:24

Julian Schmuckli

3,681
11
37
64

hi thanks for your reply. If I understand you correctly, after I store data from Android to Firebase, a script(PHP) should be triggered to store the same data into MySQL. Is it that's all what you mean? – Jin Sheng Feb 22 '18 at 09:20
Exactly, so you could set up a cronjob on server side to fetch the data every minute. – Julian Schmuckli Feb 22 '18 at 09:22
by the way, what language is most suitable for me beside PHP because I am C#/C++ based and I never learn PHP before. – Jin Sheng Feb 22 '18 at 09:23
In this thread they discussed also about .NET library https://stackoverflow.com/q/41676714/5508719 – Julian Schmuckli Feb 22 '18 at 09:24
Thank you so much for your answer, appreciated! I will surely try it out! – Jin Sheng Feb 22 '18 at 09:25
You're welcome. Don't forget to accept this answer if this answer was helpful for you :). – Julian Schmuckli Feb 22 '18 at 09:28

connect MySQL with Firebase

1 Answers1