Connect to database

[m4u_hoahoctro]

I researched about socket, httpclient, I created an android app connects to server by TCPSocket
Now I want to connect to database on server, get datas and show them, but I don't know how
I read this tutorial http://wiki.freepascal.org/MySQLDatabases , I intended to use it for my app, but my friend said MySQL/SQLite can't run on android

[taazz]

I have no idea if mysql has a client library for android but as far as I know the default database in android is sqlite. In your case I would use a 3tier design talking to a webservice on a server that will retrieve the data from the server and show them to you. This way you do not need to wait for mysql to support any OS/device you application runs on.

[Leledumbo]

If this kind of app exists on google play, then mysql (not just its client library) should be available for android. Finding that ported client library is another story, I don't think Oracle provides a pre-compiled binary so one will need to compile from source but even this is not guaranteed without tweaking. Happy hacking!

SQLite is of course supported on Android since even its core functionality depends on it.