Database configuration in Django - Step-by-Step Execution

Concept Flow - Database configuration

Start Django Project

↓

Open settings.py

↓

Locate DATABASES dict

↓

Set ENGINE, NAME, USER, PASSWORD, HOST, PORT

↓

Save settings.py

↓

Run migrations

↓

Database ready for use

This flow shows how Django reads and applies database settings from settings.py to connect and prepare the database.

Execution Sample

Django

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

Defines a simple SQLite database configuration for Django project.

Execution Table

Step	Action	Setting Key	Value Set	Effect
1	Open settings.py	-	-	Ready to edit database config
2	Locate DATABASES dict	DATABASES	dict found	Database config section identified
3	Set ENGINE	ENGINE	django.db.backends.sqlite3	Use SQLite engine
4	Set NAME	NAME	BASE_DIR / 'db.sqlite3'	Database file path set
5	Save settings.py	-	-	Settings saved
6	Run migrations	-	-	Database tables created
7	Connect to database	-	-	Django ready to use database

💡 All required database settings configured and migrations applied, database ready.

Variable Tracker

Variable	Start	After Step 3	After Step 4	Final
DATABASES	{}	{'default': {'ENGINE': 'django.db.backends.sqlite3'}}	{'default': {'ENGINE': 'django.db.backends.sqlite3', 'NAME': BASE_DIR / 'db.sqlite3'}}	{'default': {'ENGINE': 'django.db.backends.sqlite3', 'NAME': BASE_DIR / 'db.sqlite3'}}

Key Moments - 3 Insights

Why do we set 'ENGINE' in DATABASES?

The 'ENGINE' tells Django which database type to use, like SQLite or PostgreSQL. Without it, Django won't know how to connect. See execution_table step 3.

What happens if 'NAME' is incorrect?

'NAME' specifies the database location or name. If wrong, Django can't find or create the database file, causing errors. See execution_table step 4.

Why run migrations after configuring DATABASES?

Migrations create the necessary tables in the database based on your models. Without running them, the database is empty. See execution_table step 6.

Visual Quiz - 3 Questions

Look at the execution_table, what value is set for 'ENGINE' at step 3?

A BASE_DIR / 'db.sqlite3'

B default

C django.db.backends.sqlite3

D postgresql

💡 Hint

Check the 'Value Set' column at step 3 in execution_table.

At which step does Django create the database tables?

A Step 4

B Step 6

C Step 2

D Step 7

💡 Hint

Look for the action 'Run migrations' in execution_table.

If you change 'ENGINE' to 'django.db.backends.postgresql', what else must you add?

A USER, PASSWORD, HOST, PORT settings

B Nothing else needed

C Only NAME setting

D BASE_DIR path

💡 Hint

PostgreSQL needs connection details beyond just ENGINE and NAME.

Concept Snapshot

Django database config lives in settings.py under DATABASES dict.
Set 'ENGINE' to choose database type (e.g., sqlite3, postgresql).
Set 'NAME' to database name or path.
For some DBs, add USER, PASSWORD, HOST, PORT.
Run 'migrate' to create tables.
Django uses these settings to connect and operate the database.

Full Transcript

To configure a database in Django, open the settings.py file in your project. Find the DATABASES dictionary. Set the 'ENGINE' key to specify which database type you want, like 'django.db.backends.sqlite3' for SQLite. Then set the 'NAME' key to the database name or file path. For databases like PostgreSQL, you also add USER, PASSWORD, HOST, and PORT. After saving these settings, run migrations to create the necessary tables in the database. This setup allows Django to connect and use the database for your app.