Database configuration in Django

Question

How do I use a database connection URL in setting up database config in Django as opposed to using a dictionary? Instead of using:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': os.getenv('DB_NAME'),
        'USER': os.getenv('DB_USER'),
        'PASSWORD': os.getenv('DB_PASSWORD'),
        'PORT': os.getenv('DB_PORT'),
        'HOST': os.getenv('DB_HOST')
     }
 }

I want to use:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'postgresql://DB_USER:DB_PASSWORD@localhost:5432/DB_NAME'
     }
 }

There is no default way to do this, someone made dj-database-url which allows you to do exactly this. — Nico Griffioen
– Nico Griffioen, Commented Oct 25, 2019 at 11:00

uinstinct · Accepted Answer · 2020-10-29 20:42:19Z

1

This is how I added a database url to one of my django apps.

First, install this package

pip install dj-database-url

Next, add this line to your settings.py in your django project

...
DATABASES['default'] = dj_database_url.config(default=os.getenv('DATABASE_URI'))
...

In place of os.getenv('DATABASE_URI'), you can also explicitly mention your database url

You can refer here to the github repo for more configurations.

answered Oct 29, 2020 at 20:42

uinstinct

7801 gold badge9 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database configuration in Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related