PostgreSQL
===

Let's use ProstgreSQL with our Flask program. The first thing to do is install required package

## Install package
Postgre and required module for python

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib libpq-dev
pip install psycopg2 Flask-SQLAlchemy Flask-Migrate

## Setup environment

# Linux / Macos
#psql
export POSTGRES_USER=<your_current_username>
export POSTGRES_PWD=<new_password>
export POSTGRES_DB=<your_db_name>
export POSTGRES_HOST=localhost
export POSTGRES_PORT=5432

# Window: command line
set POSTGRES_USER=<your_current_username>
set POSTGRES_PWD=<new_password>
set POSTGRES_DB=<your_db_name>
set POSTGRES_HOST=localhost
set POSTGRES_PORT=5432

# Window: Powershell
$env:POSTGRES_USER="<your_current_username>"
$env:POSTGRES_PWD="<new_password>"
$env:POSTGRES_DB="<your_db_name>"
$env:POSTGRES_HOST=localhost
$env:POSTGRES_PORT=5432

Now create a superuser for PostgreSQL

sudo -u postgres createuser --superuser $name_of_user

And create a database using created user account

sudo -u $name_of_user createdb $name_of_database

You can access created database with created user by,

psql -U $name_of_user -d $name_of_database
# setup password for $name_of_user account
# Note: still in qsql console
\password
# Input password 2 times
# \q for quit

POSTGRES = {
    'user': os.environ['POSTGRES_USER'],
    'pw': os.environ['POSTGRES_PWD'],
    'db': os.environ['POSTGRES_DB'],
    'host': os.environ['POSTGRES_HOST'],
    'port': os.environ['POSTGRES_PORT'],
}

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://%(user)s:%(pw)s@%(host)s:\
%(port)s/%(db)s' % POSTGRES

>Note that if you created the name_of_user and name_of_database as your user name on your machine, you can access that database with that user with psql command.