py4jdbc 0.1.6.4

py4j JDBC wrapper

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;")