Jupyter interface to Postgres

This is a tool for writing SQL queries and executing them in an interactive notebook. It builds a portable Docker container that contains both Jupyter and a PostgreSQL server.

The database is preloaded with some tables from the DVD rental sample dataset.

Julie has written a set of SQL exercises in her fork of the repo.

Use with Binder

This repo is compatible with mybinder.org. Click the link below to launch a public online instance.

Use on your local machine

1. Install docker.
2. Install repo2docker.
3. cd into this directory and do jupyter-repo2docker .. After the image builds (a one-time operation), you'll see a link to the local server instance.

Notes

The Jupyter interface to SQL is provided by the ipython-sql plugin.