|Perl Monk, Perl Meditation
Resources for building database *server* interfaceby etcshadow (Priest)
|on Nov 12, 2004 at 17:48 UTC
etcshadow has asked for the wisdom of the Perl Monks concerning the following question:
I'm trying to find any resources (documents would be cool but modules would be great, too!) for building a database server interface in perl. Note: I am NOT talking about building a DBD. I mean: making a perl process that other processes could connect to and query by a standard database access method (quite possibly ODBC... but that's not specifically necessary). Again: this is the OPPOSITE of making a new DBD which would allow a perl process to connect as client to some database server. Anyway, just wanted to make that very clear, since it's bound to confuse folks.
So, the question is: has anyone here tried to do anything like this before? Or do you know of any work that's been done for this? Specifically, I'm looking for anything that might contribute at the layer of the connection between the database client and the perl process. I'm not looking for code that parses SQL or executes queries over data (obviously, there's already plenty of work like that around, anyway, such as DBD::AnyData, and that's not the aspect of this that I'm looking for help on). I have tried searching CPAN, but I can't find what I'm looking for, though maybe I am just being daft. If that's the case, then please correct me.
For context, what I am really trying to do is build a virtual database which fronts several actual datbases. Now, for my own code, I can obviously handle this with a phony sort of proxy DBD (actually, I don't even do that, I just built a wrapper around DBI, but that's not important). However, I'm looking into trying to hook up some third-party analysis tools, written in another language, running on another platform, etc. Now, it would be absolutely great if this third-part system could just connect to a virtual database and run queries against it, letting my code actually handle breaking up that query into the queries over the constituent data, execute them, and re-agregate them.
Thanks in advance!