Syncing android application with desktop application

Athinakis

Hello LiteSync community,
Starting the topic I will refer to a concept that I am trying to implement. I have an android application and a desktop application.
Both applications use the exact same sqlite database(same tables same variable types on the columns of each table)
What I want to implement:
If the android phone with the application is within a wifi range by pressing a button from inside the application to sync any updates have been made offline with the database on the desktop application
Also I want to have the option to make it from the desktop application.
The main problem with that concept that I find confusing is "how to determine which rows of the tables must be updated". My first answer to this is the newer ones. But I can't understand how to determine the new entries.
Also from the two youtube videos that you provide for litesync i see only insert method and not update.

Bernardo

Hi!

With LiteSync you don't need to worry about wifi range, pressing button or selecting which rows to update. All is done automatically. Including updated rows, deleted ones, new created tables, indexes, and so on...

I suggest you to make a test with the modified SQLite shell and check by yourself. You can also use the sample project for Android Studio available on the download page.

Just notice that with the current version you need to start with empty databases on both sides and then create the tables and insert the rows on one of the nodes. These changes will be replicated to the other nodes. Once that migration step is done, all new changes on any node will be synchronized to the others.

Data migration (and merging) from existing databases will be available very soon, as well as better quality videos.

Please inform if you have any problem.

Happy testing!