[DB-SIG] jdbc proxy + python driver
Randall Smith
randall at tnr.cc
Thu Jul 14 17:34:39 CEST 2005
Since I ran across type 4 JDBC drivers, I've liked the idea of their
portability and lack of dependencies. I even started work on one for
Python and am so far pleased with it. But what about databases for
which a pure Python driver can't be built? Say Oracle, who's protocol
is proprietary and undocumented (I can't find any documentation.).
Unless Oracle makes the protocol public or some protocol guru reverse
engineers it (which I think is against their license agreement), we'll
never have one.
It's been suggested to use the JDBC drivers from Jython or Jython +
XMLRPC to use in CPython. I've never liked that idea much. What about
using a Java JDBC Proxy + Python Driver for the API. Something like SQL
Relay, but more simple and written in Java. It would use the type 4
JDBC drivers and expose an API. Then a Python driver would exist to use
the service. What I like about this is that the only non-Python
dependencies are a JVM and the proxy server. Many systems already have
a JVM installed. They entire process including the proxy startup and
shutdown could be controlled from inside of the Python application
making it easy to package.
Does this exist? I did some googling, but didn't turn up anything close
enough.
Randall
More information about the DB-SIG
mailing list