Data and Visual analytics project

• This also installs pgAdmin GUI tool which makes using the database much easier.

• Setup command line command psql by placing the following in your bash_profile (or equivalent)

  alias psql="/Library/PostgreSQL/10/scripts/runpsql.sh"

• Installs the psql tool by default

• \l (list databases)
• \c (connect to database)
• \i </path/to/script> (Run script)
• \d (list tables in database)

• Install psycopg2

• Install unirest

• To work with Flask

$ pip install flask

$ pip install flask-login

$ pip install flask-openid

$ pip install flask-mail

$ pip install flask-sqlalchemy

$ pip install sqlalchemy-migrate

$ pip install flask-whooshalchemy

$ pip install flask-wtf

$ pip install flask-babel

$ pip install guess_language

$ pip install flipflop

$ pip install coverage