Django database settings

• PostgreSQL

• MySQL

• Oracle

• MongoDB (Djongo)

• SQLite

---

PostgreSQL

Install

pip install psycopg2

Use

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',

        'NAME': '<db_name>',

        'USER': '<db_username>',

        'PASSWORD': '<password>',

        'HOST': 'localhost',

        'PORT': '5432',
    }
}

---

MySQL

Install

pip install mysqlclient

Use

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',

        'NAME': '<db_name>',

        'USER': '<db_username>',

        'PASSWORD': '<password>',

        'HOST': 'localhost',
        
        'PORT': '3306',
    }
}

---

Oracle

Install

pip install cx_Oracle

Use

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.oracle',

        'NAME': '<db_name>',

        'USER': '<db_username>',

        'PASSWORD': '<password>',

        'HOST': 'localhost',

        'PORT': '1540',
    }
}

---

MongoDB (Djongo)

Install

pip install djongo

Use

DATABASES = {
    'default': {
        'ENGINE': 'djongo',
        
        'NAME': '<db_name>',
    }
}

OR

DATABASES = {
    'default': {
        'ENGINE': 'djongo',
        
        'NAME': '<db_name>',
        
        'ENFORCE_SCHEMA': False,
        
        'CLIENT': {
            'host': 'mongodb+srv://<db_username>:<password>@<atlas cluster>/<myFirstDatabase>?retryWrites=true&w=majority'
        }
    }
}

---

SQLite

Use

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