Tunnelling SQL over HTTP with MDB2
| From: | Olivier Guilyardi | 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