> It is fucki*ng hard to create a postgres database without using psql or connect directly to the database.
well ideally you would have a script to create the DB and possibly migrate it. IE this will create a PG database from `DATABASE_URL`
import dj_database_url
import psycopg2
from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT
config = dj_database_url.config()
db_conn = psycopg2.connect(host=config['HOST'],
port=config['PORT'],
user=config['USER'],
password=config['PASSWORD'])
db_conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
db_cur = db_conn.cursor()
db_cur.execute('CREATE DATABASE ' + config['NAME'])
db_cur.close()
db_conn.close()
then it's simply a matter of `fig up` + `fig run web python manage.py createdb`