Android SQLite and Data storage Pros/Cons

What is the best way for an app to push and pull data from an external database?

I want users of my app to be able to write to the database as well as view record data.

Would I use a SqLite database on a webserver somewhere? Does the database type make a difference?

Would an XML file work?

I am t开发者_C百科hinking that I can have data in my app. So, as users write new records, other users would be able to see those updates.

Suggestions? Comments? What's the best way to do this?

I personally use a local SQLite db on the android, that uses HTTPposts to interact with php on my webserver, which then accesses a mySQL instance. Communication is done through serialized JSON objects as text, gzipped. Transfers about 50kb of raw text as 10kb compressed, very manageable.

Theres lots of excellent tutorials here and otherwise, if you do a little googling for httppost android.

It is generally recommended NOT to have your mobile device have direct access to the online database, for better security and abstraction. Besides php can do some great stuff like doubly validate inputs.