Re: Tunnelling SQL over HTTP with MDB2

Hi Justin and Philippe, Philippe Jausions wrote:

Justin Patrin wrote:

AFAIK there is no current implementation of such a thing in PEAR. It sounds like an interesting idea, though (although the latency is likely to be horrible).

Latency is no problem for me, because remote access is only needed for administrative operations.

Why not just run your application on the web server where your database is located so that it can query directly?

There are many off-topic details here... I prefer to stick with the topic.

I guess what you're actually looking for is a web service front-end to a database. It shouldn't really matter what the backend database is. Once such web service is available (it may already be somewhere on the internet), then a driver for MDB2 could be added. (Could be a "Summer of code" project.)

I'm not sure what you mean by "web service front-end". I don't have to wait for anyone to make a "such web service available". I just need to install some script on the web server : this script will accept HTTP requests that encapsulate SQL queries and answer them.

Obviously there are big security concerns on running such a web service, but that's beside the scope.

There is also probably some standard or draft specifications somewhere in the Internet for that.

That may be interesting. Anyway I just realized that this should be easy to achieve with XML_RPC. And XML_RPC supports HTTPS, authentication... so security should be ok. -- og