I am making an application for android which uses sqllite database. Data for that database will be imported through website forms which uses mysql database (or mssql). What are my options in converting that database to sqllite understandable for android? It has to be automatic process that would occur every few minutes.
Hmm... App is showing a list of objects, and every object has information that can be viewed as details. Through website you can put an object in the list or remove it or change its data. So i am not sure if i can know what is changed unless i transfer sql code through json. Im not sure that is a common case in apps like this, although i really don't know
It actually sounds like a very common case. So you need to keep track which items were added, and which deleted, and which changed, since the last time you sent an update to the mobile app. In the simplest case, that would be 3 lists of the associated IDs.