MySQL in real time is like Firebase
I played around a bit with Angular4 and Firebase looking for a solution for a new large and complex project, and although I use it to work on basic stuff, Firebase JSON data schema is not like SQL I "I grew up and it seems too alien to me to think about building on there is a large and complex webapp.
I've been looking for an alternative like SQL / MySQL that will allow Angular4 to subscribe and react to changes on the DB server in real time, but haven't come up with anything yet.
Basically, I want Firebase to reach, but in a more natural query environment like SQL.
Does anyone know something like this?
source to share
I also built an app that was a hybrid of Firebase and MySQL. I used Google App Engine and set up a Firebase "listener" in a Java application that took advantage of the changes in the Firebase system. Java app turned json data into sql inserts to mysql database. Updates where almost in real time. This way, for individual users, I had instant queries on Firebase and when I needed to do aggregation between users, I used a MySQL instance. No direct writes to MySQL were allowed.
source to share