Database configuration in Django - Mini Project: Build & Apply

Database configuration

📖 Scenario: You are creating a new Django project for a blog website. You need to set up the database connection so Django can store and retrieve blog posts.

🎯 Goal: Configure the Django project to use a PostgreSQL database with the correct settings in settings.py.

📋 What You'll Learn

Create a dictionary named DATABASES in settings.py with the default database configuration.

Add the PostgreSQL engine setting as 'django.db.backends.postgresql'.

Set the database name to 'blogdb'.

Set the user to 'bloguser'.

Set the password to 'securepass'.

Set the host to 'localhost'.

Set the port to '5432'.

💡 Why This Matters

🌍 Real World

Most Django projects need a database to store data like users, posts, and comments. Configuring the database connection is the first step to making your app work.

💼 Career

Knowing how to configure databases in Django is essential for backend developers working on web applications that require data persistence.

1

Create the initial DATABASES dictionary

In settings.py, create a dictionary called DATABASES with a key 'default' that is an empty dictionary.

Django

# Your code here

Need a hint?

Use a dictionary named DATABASES with a key 'default' set to an empty dictionary.

2

Add the PostgreSQL engine setting

Inside the 'default' dictionary in DATABASES, add the key 'ENGINE' with the value 'django.db.backends.postgresql'.

Django

DATABASES = {
    'default': {
        # Add the ENGINE setting here
    }
}

Need a hint?

Set 'ENGINE' inside 'default' to 'django.db.backends.postgresql'.

3

Add database connection details

Add the following keys inside the 'default' dictionary in DATABASES: 'NAME' with value 'blogdb', 'USER' with value 'bloguser', 'PASSWORD' with value 'securepass', 'HOST' with value 'localhost', and 'PORT' with value '5432'.

Django

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        # Add NAME, USER, PASSWORD, HOST, and PORT here
    }
}

Need a hint?

Add all the required connection details as keys inside the 'default' dictionary.

4

Complete the database configuration

Ensure the DATABASES dictionary in settings.py is fully configured with all keys and values as specified, ready for Django to connect to the PostgreSQL database.

Django

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'blogdb',
        'USER': 'bloguser',
        'PASSWORD': 'securepass',
        'HOST': 'localhost',
        'PORT': '5432'
    }
}
# Configuration complete

Need a hint?

Double-check all keys and values are present and correctly spelled.