online – offline sync
# July 5, 2013 at 3:17 pm
pardon me if the title does not matches!
I have developed an WEB based APP on PHP – MySQL for the cable operators to maintain their books of records online and calculate easily which is actually done manually (about 60%).
What i wanted is to design an offline application (or implement the same website offline) to the customers which can sync data to the online database whenever wanted by the user.
Example: Github windows app (I just love it)
the thing is i don’t know how to achieve it at all !!! Hoping for some help! Thanks# July 6, 2013 at 7:12 am
You could set it up so that it creates a local Apache server when offline which would run PHP and MySQL, so that you can use the exact same app both online and offline.
You would then need to sync both the local and online databases.
I can’t explain any more than that though; it’s just an idea.# July 7, 2013 at 3:08 pm
What I meant was that when a client goes online, the database looks for something that says what they have changed whilst offline. When it finds that information, the app then sends those changes to their places in the online database. The same thing would then happen from online to offline.
You could do this with some kind of XML file or maybe in a database table with one row per client, which contains the information as to what has been updated.
This technique would sort of be like git or svn, but not as complex. It remembers which values have been changed, but not the new or old values.
You must be logged in to reply to this topic.