Android Question FTP Sqlite Synchro

[sultan87]

Hello,

I am developing a personal application that can be used from my tablet or my smartphone.
This application uses an SQLite database that I put on a server.
this is why I use FTP to retrieve the BD
How to synchronize the bd on the smartphone, the tablet and the server?
best regards

 

[Erel]

How is data added into the database? Can it be updated at the same time from multiple devices?

 

[sultan87]

How is data added into the database? Can it be updated at the same time from multiple devices?

Hello,
data are added by Insert and modify the update
Normally the data is modified on the smartphone or tablet and possibly on the pc
in principle never at the same time on different devices

Best regards

 

[Erel]

I've sent you a private message about the other question.

If the database is only updated in one location at a time then you can simply copy the most recent db file to the other locations (with FTP).

 

[sultan87]

I've sent you a private message about the other question.

If the database is only updated in one location at a time then you can simply copy the most recent db file to the other locations (with FTP).

Hello,

thank you for your reply

in this case, we must start to make a ftp downloader DB and end of the program to ftp to upload the db
1 - How to be sure that the db has been copied when the application exits?
2 - to avoid the download at the beginning of the app, you can check the date of update on the ftp and date update locally?
3 - must be necessarily connected Wifi, if this is not the case, we can work on the basis locally, but we must have the possibility of a next launch when to check the dates of the DB on the FTP and DB locally.
4 - can we have a BD on a server and update the database on the server, if so what type of comic?
Currently, I store my comics on my personal website at FREE.
FREE on, you can have BD MySql or ProgressSql
Is there a server SqlLite free website and what can we host?
What do you think?

Best Regards

 

[Erel]

1) Don't wait for the app to exit. Android will kill the process when it is in the background. You can start a service that will upload the file when the activity is paused.

2) You can check the file date. See FTP.List.

 

[sultan87]

1) Don't wait for the app to exit. Android will kill the process when it is in the background. You can start a service that will upload the file when the activity is paused.

2) You can check the file date. See FTP.List.

Hello,
thank you
I am creating my site Free a MySql database
I downloaded your example MySql.zip
I analyze and I test
I would return to you for the record
Best regards