Custom settings for database alias

[Miguel Angel Velazco]

It could be excelet to be able to set custom settings depending the database alias. An excelent example could be the management of the media files.

Maybe to do something like this:

settings.py

import os
BASE_DIR = os.path.dirname(os.path.dirname(__file__))

DATABASES = {
   'default': {
            'ENGINE': 'django.db.backends.sqlite3',
            'NAME': os.path.join(BASE_DIR, 'uno.sqlite3'),
    },
    'another': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'uno.sqlite3'),
        'ADDITIONAL_SETTINGS': {
            'MEDIA_ROOT': os.path.join(BASE_DIR, "custom_media"),
        }
    },
}

Is important to say that this custom settings should be applied when a database router switch databases.

[Carl Meyer]

Thanks for the suggestion. I don't believe this feature is possible, though, because settings are process-global, whereas you can easily have multiple threads of execution each talking to different databases at different times.

In general, changing the value of settings at runtime is not safe or supported.