angularjs - mySQL authoritative database - combined with Firebase -


We have created a LAMP-stack API via PHP Laravel. It currently uses a local mySQL example we have mostly considered in AngularJS.

In order to use Firebase, we need to synchronize data between official stores in our SSQL, which is anything relevant to the firebase, as close to the real time as possible. This means that other parts of the app that are not real time and do not use firebase, they can present fresh content that has recently been registered in the system.

I know that Firebase is basically a database in a noSQL cloud. My question is how can I write a cover for synchronizing the canonical version of my firebug into my database of records - mySQL?

Updates to answer - our final decision - an option

We have decided against it, because we can easily access a socket .io example, which has a very low latency connection to mySQL, so that both can stay in sync. There is no need to go to the web when resources and finishing points can exist on the localhost. It also gives us the option to run our app without any internet connection, which is important if we sell on-premise equipment for large companies.

An SSQL sync platform like Firebase is actually just a temporary shop, read / writes fast in semi-real time if they try to join "We also keep everything for you" - that asks a different with a lot of commitment.

The final stability guarantee between MySQL and Firebase is necessary to get the correct first. In addition to stopping the problems below the line, an RDS is required for our app - in our analytics / data mapping Too many data-the only way to attack massive problems - is the reason that most of the world still uses RDMS like my SQL, etc. You can make them very reliable - through Amazon RDS and Google Cloud SQL.

There is no special problem beyond real-time synchronization scaling, which the firebase actually solves for us, which other open source frameworks do not already solve if their JSL actually does offline scenarios (when You start offline), I can understand it, but it does not do so yet.

So, YMMV - but in our specific case, we are not considering the firebase for the reasons above.

The entire theme is incredibly broad, definitely very broad to provide a comprehensive answer .

I will be in the use case provided in the comment:

Think that you have a checklist in MySQL, which includes a set of features and steps . The steps are stored in another table. When someone updates this checklist on firebase - how do I sync my SSL?

If you insist on the combination of Firebase and mySQL for this usage case, then I do:

  1. A work row Set your firebase as: var ref = new firebase ('https://my.firebaseio.com/workqueue')

  2. Customer Is pushing a working item in a firebase:

    The server is that:

    1. Work Tracks the queue ( ref.on ('child_added' )
    2. Updates the item to your SQL database
    3. This guitar For example, one line at the top of Fayrbse project:

      / div>

Comments

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

javascript - data.match(var) not working it seems -

javascript - How can I pause a jQuery .each() loop, while waiting for user input? -