How can I use multiple databases in Django?

How can I use multiple databases in Django?

You can configure multiple databases in Django by adding them to the DATABASES setting in your settings.py file.

Can you give me an example of how to set that up?

Sure! In your settings.py, you can define your databases like this:

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 different databases?

You can use Django's database router to direct queries to the appropriate database based on your logic. You need to create a router class and define the db_for_read and db_for_write methods.