how to exchange data between online and offline

[Otto]

Hello,
How should we organize the exchange of data between online and offline.
SQL Transfer or FTP?

Thank you in advance
Otto

[Otto]

Dear Antonio,
When mod harbour servers are ready, how do you suggest to upload data from desktop to the server?
Best regards
Otto

[Antonio Linares]

Dear Otto,

SFTP or SSH

You can use midnight commander to easily do it

[Otto]

Dear Antonio,

Thank you.
What is if FTP is blocked.
I ask, as in many cases, sysadmins block FTP at the customer side.
Are there other ways. HTTP?
Thank you and best regards
Otto

[Antonio Linares]

Yes, http can be used too

Please review mod_harbour\samples\sendfile.prg

[TimStone]

Here is a broader consideration.

Some commercial applications are synchronized with the online database. That means the data pool exists on both the cloud server, and the local machine. If an internet connection is lost, the user continues to work on the local machine / data, but when the connection resumes, the data is automatically synchronized. In this scenario, the actual forms, etc, are maintained on the local machine ( app ), but the data is maintained in the cloud.

IMO, when we can accomplish this, we truly add deep value to our offerings.

[Antonio Linares]

If we are talking about a web app then "local storage" limitations apply:

https://stackoverflow.com/questions/2989284/what-is-the-max-size-of-localstorage-values