SQLite, MySQL or Both for Android Application

Question

I'm in the process of designing an Android application right now.

I understand SQLite works on the phone device within the file structure. However I'm not sure if it's practical for our use.

If I'm wanting to store data that's available to all users (i.e. if someone updates their profile, it can be seen by all other users), can that be done using SQLite somehow? Or must we use a client-server model such as MySQL?

Is it practical to store user-specific information using SQLite and public information using MySQL?

Thank you

Answer 1

What you want to do is a Client-Server Architecture, store the data in your central server and get a copy of the working data on the phone. MySQL and SQLite don't share everything but it's close. Read the documentation on SQLite and you will see. SQLite can't serve files like MySQL if that's your question via the network. You'll have to write that on your own. I suggest making a webservice.