add Meta option when working with multiple databases

[Chris Curvey]

when working with multiple databases, I'd like to see the database specifier as an option in the Meta section of models, so that you're not repeating your database names everywhere. For example:

in settings.py:

DATABASES = { 
  "default" : {"ENGINE" : "mysql"....},
  "foo" : {"ENGINE" : "postgres"...}
}

then in your model.py file, you would have:

class Bar(models.Model):
  class Meta:
     db_name = "foo"

The existing "using" method works fine, especially if you are dealing with sharding, but if you're working with models that are just in different physical databases, then it would be nice to be able to specify the location in one place and not every time you do a query (.using("foo")) and every time you do a save ( .save(using="foo"))

(This may exist somewhere and I just can't find it in the docs yet. Django people are sometimes smart like that.)

[Alex Gaynor]

This was originally implemented, however it was since rejected (the rationale for this is explained here: ​http://alexgaynor.net/2009/nov/27/why-metausing-was-removed/). If you take a look at the django-developers mailing list Russell Keith-Magee has just proposed a far more comprehensive solution to database pinning and other schemes.

[Chris Curvey]

I agree. The "database router" solution is a FAR better solution. Glad to have been wrong on this one!