Tunnelling SQL over HTTP with MDB2

From: Date: Tue, 25 Apr 2006 14:16:20 +0000
Subject: Tunnelling SQL over HTTP with MDB2
Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-42375@lists.php.net to get a copy of this message
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 ? What about DB ? Greetings, -- Olivier Guilyardi

« previous php.pear.dev (#42375) next »