[Django]-Heroku Database Settings Injection – How do I setup my dev django database?

Use this in your settings.py:

DATABASES = {'default': dj_database_url.config(default=os.environ['DATABASE_URL'])}

and in your .env file have this:

DATABASE_URL=postgres://localhost/yourdbname

when you launch with “foreman start” it will look at the .env file and create all those environment variables, just like running on Heroku itself. Type “heroku config” to confirm that you have a DATABASE_URL set, which you should if you added the postgres database addon.

Just set an environment variable on your operating system and check weither or not it’s set. For instance, with a UNIX system:

# In ~/.bash_profile
export LOCAL_DEV=true

# In settings.py
import dj_database_url
DATABASES = {'default': dj_database_url.config(default='postgres://localhost')}

if bool(os.environ.get('LOCAL_DEV', False)):
    # Override DATABASES['default'] with your local database configuration

Also, if you need to set an environment variable on your heroku space:

heroku config:add MY_VAR='my_value'

I just tried this and here is my code:

import dj_database_url

local_db = 'postgres://django_login:123456@localhost/django_db'
DATABASES = {'default': dj_database_url.config(default=local_db)}

My database name is “django_db”, user name is “django_login”, password is “123456”.

My code can run both in local machine and heroku.

import dj_database_url

DATABASES = {‘default’:
dj_database_url.config(default=’postgres://yourusername:yourpassword@yourhosturl:5432/yourdbname‘)}

** Replace bold string with your database settings
if you are using local database then replace yourhosturl by localhost