Public | Automated Build

Last pushed: 2 years ago
Short Description
Jupyter Notebook Data Science Stack plus SQL extension
Full Description

Data Science Notebook plus SQL extension

jupyter/datascience-notebook/ plus following modules.


Set external port mappings to set environmental variables.

$ source .envrc

Start up PostgreSQL database and Notebook containers.
After up, check the processes are running.

$ docker-compose up -d
$ docker-compose ps

To interact with database on cosole, use pgcli service.

$ docker-compose run --rm pgcli

Test data

Use pagila as test data.

At first, clone the repository from GitHub.

$ cd data
$ git clone
$ cd pagila
$ git checkout pagila-0.11.0
$ cd ../..

Run SQL queries on pgcli container.

$ docker-compose run --rm pgcli psql -f /data/pagila/pagila-schema.sql
$ docker-compose run --rm pgcli psql -f /data/pagila/pagila-data.sql
Docker Pull Command
Source Repository