Im working on an app that works with sql lite database which retrieve information from the database when user click on an item from the list view. Everything working fine now. I wish to implement a features which allow users to make comment ( sort of like how wikipedia works, user can update the article and its send to the admin to verify )
User download my app with a pre install client side database. When user is offline, any comment make by the user will be save somewhere until the app detected that the user have internet connection, which allow user to sync with the server database.
1) Firstly my question is, if im trying to code the user comment part, should I create fields and save the data in another table of sql database and sync with the server database or is there a better approach?
2) Secondly, im not so sure about the synchronising of the database, been searching in google and looking and demoapi but did not help much, any suggestions?
I welcome any suggestion from the friendly developers here!