There is a website with a database on MySQL, how to make an offline android application for it?

Question

Android

Hello!
There is a site-catalog on mysql-base, I want to make an offline android application.
For a person to install the application and then watch the catalog offline.
And for example, the -news- section through the application would already be loaded from the Internet online ...
And for example ... once a week ... a button would appear in the application ...
"Update database" ... and when pressed, the database was updated offline applications...
tell me how to do it? it is desirable to link to methods) because
I'm not a very advanced pro, but I'm still learning)
Maybe there are ready-made methods for this?
Thanks to all!

Answer 1

Export the database to sqlite. Write an application that will select and display.
( developer.android.com/training/basics/data-storage... )
Remember the last update time. If a week has passed, then offer to update from the Internet. At the same time, it will not be correct to pour the entire database over a new one, but only changes (for this, you control versions of the database on your server and give the current diff)
Instead of ready-made methods, look for open source applications with similar functionality on github

Answer 2

I was told that a SQLite database is used on a mobile phone ... in this regard, do I need to convert MYSQL to SQLite online and transfer it to the user? Am I understanding correctly or not?