How to design a client-server android application?

Question

Android

The application must: -
work offline and save data, after the appearance of the Internet, synchronize changes with the server.
- as it is already clear from the requirement above - a local database that duplicates the server one.
How to design correctly and what frameworks to use?

Answer 1

MVP - architecture.
Dagger 2 - D.I.
Retrofit 2 for the web.
SQLite, Realm - for the base.
ORMLite, GreenDAO - if you want an ORM. You can also look at Storio.

Answer 2

If it is possible to connect directly to the server database, and not via API (HTTP), then it is better to take the same local database as on the server, for example, raise MySQL locally (via JDBC), and not use SQLite - the classic embedded ( local) DB for Android, which differs in query syntax, etc.