A simple Jupyter kernel for PostgreSQL

I don't know how to set this up to be pip-installable, but maybe you can help with that?

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

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

Todo

• Get rid of this ShimWarning, "You should import from ipykernel or jupyter_client instead."
• How do I make this pip-installable?

Related

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