Can I use MySQL with Android or do I have to use SQLite?

When using a database for an 开发者_JAVA百科Android application, is it possible to use a MySQL database, or do you have to use SQLite?

What I'm trying to do is make an app that allows users to see events on a map. These events are updated by admin staff from the office from a Java-based application that works with the MySQL database.

SqLite is present on the phone with some good tutorials out there to get you started using it.

Check the online docs for more details, and I suggest taking a look at the notepad sample, it will get you up to speed in no time.

http://developer.android.com/guide/topics/data/data-storage.html#db

As far as I know you have to use sqlite. MySQL needs a server which would mean you'd need a locally hosted mysql server on a phone which is going a bit overboard.

you have to use sqlite for your android side database

The best is to use content providers if you want to share information. Android provides built in interface for sqlite (android.database.sqlite) and so sqlite is easiest to use.

Another alternative to Sqlite is Berkeley DB for Android (Berkeley DB - Java Edition)