Android Question Synchronize remote Database

[azzam223]

hello I need to Synchronize my remote database what is the best way to do that

I want to sync database tables every time If I load all data in local database and then make some query to add and remove the data that changes is this best way to sync or there are best way

 

[Erel]

There are all kinds of ways to synchronize databases. The exact details depend on the exact requirements.

One possible and relatively complete solution is CloudKVS.

 

[azzam223]

is this is the best way if I have big databases

 

[azzam223]

Erel How can I use CloudKVS with my database If all tables have changes

 

[Erel]

You need to first learn how CloudKVS works.

 

[azzam223]

I know that Erel But My question is How I can Add this feature To my data without Create New tables I need the make the changes To my tables not to another tables

 

[Erel]

It is not possible. CloudKVS is a key value store.

 

[azzam223]

Ok Is there Another way To Do that

 

[Erel]

Yes. Send queries and request the new data (based on a date column) and upload the new local data.

 

[KMatle]

is this is the best way if I have big databases

Whay do you need a full sync? You never synchronize a big database with a "small" device (except you need a backup at a 2nd db server). Just show the first 100 rows and retrieve the next if needed.