Django using multiple databases

Question

I have a model called FieldMap which is used throughout my project. I decided recently that the physical database for this model will exist on another machine (other than the default).

So I now have two databases setup in my settings: default and dev.

I can use both databases like this:

FieldMap.objects.using('dev/default').all()

Because my project has already been written, I dont want to have to go through code and make the changes every time I read/write from this model.

So after all that, I was wondering if there is a way to tell a model which database to read/write from by default?

We have a dev and live server. The FieldMap data needs to be kept identical on both — neolaser
– neolaser, Commented Nov 14, 2011 at 23:31
Perhaps you should have asked: What is the best way to keep my development database in sync with my production database? — mikerobi
– mikerobi, Commented Nov 14, 2011 at 23:46
I didnt want to put any more stress on the live server and figured there was no point in keeping them in sync constantly as it would be redundant. Also having researched this a little bit, I became curious as to whether this was possible. — neolaser
– neolaser, Commented Nov 14, 2011 at 23:58

Bodie · Accepted Answer · 2011-11-15 00:56:24Z

3

Consider writing a custom database router that decides the database to use on the fly.

https://docs.djangoproject.com/en/1.3/topics/db/multi-db/#database-routers

answered Nov 15, 2011 at 0:56

Bodie

311 bronze badge

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

Collectives™ on Stack Overflow

Django using multiple databases

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related