Jupyter Notebook Python GIS Stack with host PostgreSQL support example

connection.py

import psycopg2
conn = psycopg2.connect("dbname=db host=/var/run/postgresql/ user=user")
cur = conn.cursor()
cur.execute("select * from datasets.intervals;")
cur.fetchone()
cur.close()
conn.close()

start.sh

docker run -d \
    -p 8888:8888 \
    -v "$(pwd)/notebooks:/home/jovyan/work" \
    -v "/var/run/postgresql:/var/run/postgresql" \
    --name gis-notebook \
    urbica/gis-notebook start-notebook.sh --NotebookApp.allow_origin='*'