Re: Tunnelling SQL over HTTP with MDB2

Olivier Guilyardi wrote: > 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). > >> 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.) > >> 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. > With the new Query2XML that just got accepted, and by using XML_RPC or Services_Webservice package to create the web service (server), putting together a web service frontend to a database (using an MDB2 object for instance) shouldn't be that hard. A driver for such webservice could be added to MDB2. That won't be blazzing fast, but should be very reusable... There are certainly a lot of different approaches to the topic though, so it is often best to stick with (defacto) standards. -Philippe