Re: Tunnelling SQL over HTTP with MDB2

On 4/25/06, Olivier Guilyardi <ojaiml@nerim.net> wrote: > 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. > He just means that *you* need to have a webservice which does this. This is essentially what you're asking for, a webservice which allows querying of your database. > > 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. > And you must understand the above as you mention XML_RPC here which is used for many webservices. By definition this will be a webservice. -- Justin Patrin