Django: Detect database backend

database django backend detect
jaap3 picture jaap3 · Sep 17, 2013 · Viewed 7.8k times · Source

I'm doing some "extra" queries in Django that need to work on both sqlite and postgres. The syntax of these queries varies between backend but I have no way of figuring out if I'm sending my queries to either postgres or sqlite.

Is there a way to get the current database adapter so I can branch my code and send the right query for the active database server?

Answer

jaap3 picture jaap3 · Sep 17, 2013

OK, so there's two ways of doing it, as @Ricola3D said there's the option of checking settings.DATABASES['default']['ENGINE']:

>>> from django.conf import settings
>>> settings.DATABASES['default']['ENGINE']
'django.db.backends.sqlite3' or 'django.db.backends.postgresql_psycopg2'

But there's also an (undocumented) vendor property on a connection:

>>> from django.db import connection
>>> connection.vendor
'postgresql' or 'sqlite'

Either way works. I personally prefer connection.vendor as it looks prettier :)

Related questions

OSError: [Errno 18] Invalid cross-device link

I'm working with django 1.6.5 and python 2.7. I have import feature in my app and I get error: OSError: [Errno 18] Invalid cross-device link I have problem with this part of code: os.rename(db_temp, settings.DATABASES['bookmat']['NAME']) code in …

Read More
Django Model() vs Model.objects.create()

What it the difference between running two commands: foo = FooModel() and bar = BarModel.objects.create() Does the second one immediately create a BarModel in the database, while for FooModel, the save() method has to be called explicitly to add it …

Read More
How to reset db in Django? I get a command 'reset' not found error

Following this Django by Example tutotrial here: http://lightbird.net/dbe/todo_list.html The tutorial says: "This changes our table layout and we’ll have to ask Django to reset and recreate tables: manage.py reset todo; manage.py …

Read More