Android Question Update database in app and server

[yfleury]

I have sqlite in app and a Mysql via jrdc2 serveur at home.
Each row on all table have a time(unix) Each time a row is update, the time is update too.
Many devices running my app use same data
Each time a device run the app, I want to restore data from serveur with the latest data and keep in app the latest data from app.
When user close the app. I have to backup data in app to server with uptodate

How to keep the latest data on sqlite in app and mysql serveur? Any clues?

 

[ronshahrokh]

create Api server

 

[yfleury]

And what is an api server

 

[aeric]

Use okHttpUtils to download and upload your data.

 

[TILogistic]

I have sqlite in app and a Mysql via jrdc2 serveur at home.
Each row on all table have a time(unix) Each time a row is update, the time is update too.
Many devices running my app use same data
Each time a device run the app, I want to restore data from serveur with the latest data and keep in app the latest data from app.
When user close the app. I have to backup data in app to server with uptodate

How to keep the latest data on sqlite in app and mysql serveur? Any clues?

tips:

Check the process logic of these examples.

[B4X] CloudKVS - synchronized key / value store

CloudKVS solves a difficult and common problem. The user needs to work with online data, however as this is a mobile app we cannot assume that the device will always be connected to the remote server. With CloudKVS the app always works with a local database. If the device can connect to the...

www.b4x.com

Erels [B4X] CloudKVS - synchronized key / value store - MySQL

Well, It's Erels... [B4X] CloudKVS - synchronized key / value store... with the b4j server using a MySQL back-end. This is a moderate programmer project. Not really for a new-bee. Thanks Erel!!!!! https://www.b4x.com/android/forum/threads/b4x-cloudkvs-synchronized-key-value-store.63536/ Not...

www.b4x.com

 

[yfleury]

Thanks @oparra

Just to be sure I understand well. KVS cant take all my database (if I want) and put it in mysql database and vice and versa. Then overwrite my data on serveur even if data is yonger than app data. Is it right?

Just to be clear for my request.
I want to have the most update data on both side (my app database and server Jrdc2 mysql database)
To help, each row have a field filled with datetime.now when it update in app database
if a row in app data is most recent than row in mysql (jrdc2 server) then I update it on server
if a row on server is most recent than row in app data then i update row in app data.

 

[yfleury]

Finaly I make a subroutine for each table of app database

I load server table in list (custum Type)
I compare each row of app table and type in list for difference.
Then I make an update, insert (for new row) in app table. Then a table in app is up to date.
To be sure the server table have all data (if a new row in app table). I delete all row in server table and insert all row of app table. The a table on server is up to date.

I think that be ok.