Install

PostgreSQL Server

Mac OS

brew install postgres

Windows (Installer)

Windows (Zip-ARchiv)

Download postgresql from https://www.enterprisedb.com/download-postgresql-binaries

Configure

Initialize database:

initdb.exe -D ../data –-username=postgres –-auth=trust

Start the database:

pg_ctl.exe start -D ../data

Log into the database:

psql –-username=postgres

Create a password for your user:

ALTER USER postgres WITH PASSWORD ‘VeryVerySecret’;

Install adminpack extension:

CREATE EXTENSION adminpack;

Manage Users

Preparation

psql postgres

List all Users

postgres=# \du+

Create Superuser

 create role superuser superuser login password 'pAssw8rd';

Change Password

Postgres Utilities

• pgAdmin
• PSequel, a PostgreSQL GUI Tool for macOS

Documentation

• Upgrade
• Migrate existing data from a previous minor version (9.0-9.5) of PostgreSQL
• PostgreSQL command line cheatsheet (github.com)

Working with

Possible Solutions

• plumbum Github
• XonSH Github (git clone https://github.com/xonsh/xonsh.git)
• IPython
• Sarge Source (hg clone https://bitbucket.org/vinay.sajip/sarge)
• sh Github (git clone https://github.com/amoffat/sh.git)

Plumbum

Install: pip install plumbum

Documentation

• Open SCAD Dokumentation
• Beginner Tutorial

Introduction

iPython ist ein Kommandozeileninterpreter zum interaktiven Arbeiten mit der Programmiersprache Python. 

IDEs and Environments

• iPython
• Jupyter
• Anaconda

Install 

Jupyter

$ virtualenv --python python3 jupyter
$ cd jupyter
$ . bin/activate
$ pip install --upgrade pip
$ pip install jupyter

Finally run jupyter

jupyter notebook

Anaconda

$ virtualenv --python python3 anaconda
$ cd anaconda
$ . bin/activate
$ wget https://repo.continuum.io/archive/Anaconda3-4.3.1-Linux-x86_64.sh | bash

jupyter notebook

Resources

Awesome Notebooks

• A gallery of interesting Jupyter Notebooks
• Notebook Gallery – Links to the best IPython and Jupyter Notebooks
• nbviewer – A simple way to share Jupyter Notebooks

Notebooks

• Data Science iPython Notebooks
• Learn Data Science
• Mining the Social Web