Dear all,
I have the following issue to address;
I am building an application that has to work either if there is internet or not.
If there isn’t internet connection, the application should be able to work offline, and when there is connection, I should be able to sync with the database hosted in a remote server.
Is there a way to implement this feature using SCRIPTCASE?
kind regards,
JSD
You have to deploy a local webserver and sync data using replication for example.
SC apps are PHP. PHP needs a web server to be run. If your server is on “cloud”, and you don’t have internet, you can’t reach the “cloud” server.
Then, most optimal way, is to work with a local database, and replicate data when internet is available. For example, using mysql replication capabilites, or your own logic for replication.
Without more data to know about your project, data modelling and so on, is dificult to say.
I really appreciate your insights
I know the question was vague, but there you said that Mysql has replication capabilities. Will research a bit more and comeback with more details.
thankyou,
JSD
https://dev.mysql.com/doc/refman/5.6/en/replication.html
You don’t need replication at all as is, but replication is automatic. You can too detect if you have or not connection, if not, you work with a local sqlite database for example, and once connected, send the data to the “cloud” database. Is almost the same, but manual
There are tools to run php applications as if it was a local application. See i.e. NuSphere for details. Not sure if that’s a right solution for you though.
and PHPDesktop
Great!
more options to find a suitable solution.
still working on it…
Cheers!
JSD