php - Selective syncing of MySQL database with SQLite -


i'm trying develop android app provides information on chosen topic. information stored on mysql database 1 table each topic. want achieve when user chooses topic, corresponding table should downloaded sqlite can used offline. also, changes particular table in mysql should in synced sqlite db automatically when phone connects internet next time.

i have understood how achieve connection using php , http requests. wanna know best logic sync entries in particular table in musql database 1 in sqlite. read using various sync services don't understand how use them. tables have same schema there efficient way achieve sync ?

i have decent knowledge in sql i'm kinda new android.


Comments