How do I set up multiple databases in Django?

How do I set up multiple databases in Django?

To set up multiple databases in Django, you need to define them in your settings.py file under the DATABASES setting.

Can you show me an example of how to configure it?

Sure! Here's a basic example:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    },
    'secondary': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'mydatabase',
        'USER': 'myuser',
        'PASSWORD': 'mypassword',
        'HOST': 'localhost',
        'PORT': '5432',
    },
}

How do I route queries to the correct database?

You can route queries by using database routers. Create a router class and implement the db_for_read and db_for_write methods.