How to change database dynamically in Django?

Question

Is it possible to change active database dynamically in Django?
For example, use one DB for inserts and updates and switch to other for readonly operations.

You have multiple database connections in your settings. Have you read this? docs.djangoproject.com/en/1.3/topics/db/multi-db — S.Lott
– S.Lott, Commented Jun 29, 2011 at 14:22

Manfre · Accepted Answer · 2011-06-29 14:23:53Z

7

This is possible by configuring multiple databases in your settings and then using a router to specify which database configuration should be used for read and write.

Go to https://docs.djangoproject.com/en/1.3/topics/db/multi-db/#database-routers and look for "MasterSlaveRouter", which has example code for exactly what you are requesting.

answered Jun 29, 2011 at 14:23

Manfre

1,24510 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cerin · Accepted Answer · 2020-01-16 18:45:58Z

1

It's also possible to manually select databases in queries and saves as explain in the Django Docs on multiple databases

Essentially one uses the "using" keyword argument, as in

obj.save(using='alias')

and the "using" method of the QuerySet like this:

Model.objects.using('alias').all()

alias is the name given to the database in the DATABASES item of the settings.

edited Jan 16, 2020 at 18:45

Cerin

65.6k106 gold badges349 silver badges561 bronze badges

answered Jan 21, 2013 at 11:11

Ber

42k16 gold badges79 silver badges90 bronze badges

Collectives™ on Stack Overflow

How to change database dynamically in Django?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related