Skip to content

jochumdev/py4jdbc

Repository files navigation

Py4jdbc

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 with pip

pip install py4jdbc

Install from source tarball

tar -zxf py4jdbc-V.X.Y.Z.tar.gz cd py4jdbc-V.X.Y.Z python setup.py install

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