Re: Tunnelling SQL over HTTP with MDB2

On 4/25/06, Olivier Guilyardi <ojaiml@nerim.net> wrote: > Hi, > > As you all know many hosting providers only permit access through the database > server from the web server, not from the outside. > > I'm currently on a professional project where such remote database access is > needed. There is a simple solution : encapsulating SQL queries into HTTP requests. > > There's a project out there named "PHP Tunnel" that does that : > http://www.mysqlfront.de/manual/fphptunnel.html > > But wouldn't it be great if that was handled as part of the abstraction that > MDB2 offers ? > > One would call $mdb2->query() as usual and that could run on a local or > remote-over-http server.... > > This would simply require to write a new MDB2 driver, and a little server-side > script to perform the real database queries. > > The only critical part I see is at the authentication/security level. > > Or have I missed something ? Is this already possible ? 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). Why not just run your application on the web server where your database is located so that it can query directly? > > What about DB ? > Don't waste your time unless you're using something which relies on DB specifically. MDB2 is the official DB abstraction layer in PEAR now. -- Justin Patrin