A simple Jupyter kernel for PostgreSQL

This requires IPython 3.

To use it, install with pip install postgres_kernel, and then run one of:

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

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 :)

• Figure out how to point at other databases, not just default settings for psycopg2.connect
• Get rid of this ShimWarning, "You should import from ipykernel or jupyter_client instead."
• How do I make this pip-installable?

• Catherine Devlin has an ipython magic that seems very full featured: catherinedevlin/ipython-sql
• As noted, this is based on takluyver/bash_kernel