Offline Android app with online sync

Question

I am developing an Android application that will have offline data at startup and online synchronization. This means: the user clicks on the element, and the application reads the data for this element from the stand-alone (database or SQLite file) and displays this action with data (text, image, film, etc.). At the same time (if online), the application enters the webservice in the background and downloads the data if the data version is a newer version on the mobile device, replaces the data in the background and informs the user that newer data is available (if the user is still located on the same element - the same activity). If this is not the case, the application automatically reads the new data the next time the user clicks on the same item.

Is SQLite on the phone the best way for this or file? Can I put SQLite with offline data in the extension file when I upload the .APK to Google Play?

Answer 1

The answer depends on what types of data your application works with. If you have a lot of data files (pictures, movies, mp3s), you probably want to store both files on your phone and store dates and version information and files in the SQLite database so you know when they need to be updated.

The extension file is probably not the one you are looking for. It is really intended for large datasets of rarely changing data, such as huge 3D textures or large videos referenced in the game.