Johntron Speaks

Django 1.2 will contain support for multiple databases, according to Simon Willison (@simonw). Good news for people trying to scale their web application or building intranet services.

This addition means you will be able to do the following:

# In settings.py
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': 'data.db',
        'USER': '',
        'PASSWORD': '',
        'HOST': '',
        'PORT': '',
    },
    'production': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'multidb_demo_production',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '',
        'PORT': '',
    }
}

>>> from blog.models import Entry
>>> Entry.objects.all()
[]
>>> Entry.objects.using('default').all()
[]
>>> Entry.objects.using('production').all()
[, ]
>>> e = Entry.objects.using('production')[0]
>>> e._state.__dict__
{'db': 'production'}
>>> e.save(using = 'default') # WARNING: Over-writes SQLite item with same pk
>>> e

Tags: databases, django

This entry was posted on Wednesday, December 16th, 2009 at 1:02 am and is filed under programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.