py4j JDBC wrapper
Project description
Py4jdbc is a (mostly) dbapi 2.0 compliant interface to JDBC. It’s similar to JayDeBeAPI, but uses a much more efficient JVM backend process implemented with Py4j instead of JPype.
Install py4jdbc
You can also pip install py4jdbc, but you’ll have to manually dig up the jar file and add it to your $CLASSPATH.
Example
A simple example that starts a JVM subprocess:
from py4jdbc import connect conn = connect("jdbc:postgresql://localhost/postgres, user="cow", password="moo") cur = conn.cursor() cur.execute("select 1 as cow;")