mysql and remote read/write

[Robdav]

morning all,

I'm investigation options for some development work I want to do.

Basically I want to use two methods for writing and reading from a remotely hosted MySQL database.

First method is via a vb.net app running on one of my servers. this will create data and write it into the DB.

Second method is via an android app which will pull data from the DB but will also write updates back to the DB on occasion.

So in a nutshell... VB.NET <-> MYSQL <-> android

I don't currently have the option to host the database myself.

am I going to run into a wall here is terms of security issues with the hosting company (yes I've asked, just waiting for a reply from them) and if so is there another way around this??

 

[Deleted member 77746]

You don't give enough info.

1) What host are you using
2) How do you currently read/write to the sql database.

 

[Robdav]

hosting via Red Fox and I am not currently doing any writing as this is an investigation into if what I want to do is actually possible.

 

[kkelly]

Web service?

 

[Robdav]

web service? ok tell me more..

 

[planty]

You want to host a web service which will talk to mysql rather than have your applications talk to the database directly. You can lock-down the web service however you like (ssl, user accounts, etc.). Your applications will call methods on your web service and the web service back-end will do the database stuff and return results back to your apps.

 

[Fallen god]

To add to what planty said you build a restful backend which has simple http methods e.g. url/user/{id} [GET] which will then tell the backend (VB.net) To get user with the id from the database.

Here is a good source.

http://www.vinaysahni.com/best-practices-for-a-pragmatic-restful-api

 

[planty]

^^ excellent source, I found that helpful when I first started looking at restful web services.

 

[Robdav]

thanks chaps. something I didn't consider. I'll have a read.