Android Remote Mysql Operations Using A Web Service With Php

I read some nice articles about how to connect to a remote MySQL database via Android. Found some really interesting links here and here. So the common way for getting data seems t

Solution 1:

I would recommend keeping anything database-specific hidden behind a web service.

If you build a dependency on MySQL into your application and later find that you need to change databases, the entire installed base has to be cut over. Think about the logistics of accomplishing that for a few minutes and you'll start to realize it's a nightmare.

Solution 2:

Premiumsoft's Navicat for MySQL comes with a HTTP tunnel (PHP script) you might be able to use. It basically provides a method for doing anything to a MySQL database over HTTP.

I'd just make sure there are no licensing issues if you plan to distribute your app.