How to write a remote database from an Android application

Question

We have an Android application that is currently sending data to a php script that writes to the mysql database on the same server. We are thinking about using a scalable database server, for example. FathomDB (which is based only on Amazon RDS and rackspace), so we can easily handle the load.

The question is, how does our Android application write these remote databases? Do they have some kind of relaxation API or can you have a php script similar to the one we have at the moment?

Answer 1

I would say that most of these services have a connector that works on the Internet, for example, the one you use. But some of the services you mentioned (e.g. amazon rds) have a native mysql connection. This way you can connect using mysql to the server and run queries like the ones you do in php. You can use security ACLs in your application :)