A simple Jupyter kernel for PostgreSQL

Install with pip install postgres_kernel

To use, run one of:

jupyter notebook
# In the notebook interface, select PostgreSQL from the 'New' menu
jupyter qtconsole --kernel postgres
jupyter console --kernel postgres

How to use:

There are a couple of specially formatted comments for controlling the connection string and autocommit mode.

-- connection: postgres://brian:password@localhost:5432/dbname
-- autocommit: true
-- (or false)

For details of how this works, see Jupyter's docs on wrapper kernels. This is heavily based on takluyver/bash_kernel. Just look at our git log :)

Related

• Catherine Devlin has an ipython magic that seems very full featured: catherinedevlin/ipython-sql

• As noted, this is based on takluyver/bash_kernel