How to write your own django relational database backend

Question

In my django application, I need to support data coming from a data source supported by Composite Software . Composite provides its data on jdbc / odbc, but uses non-standard sql syntax. I tried using django-pyodbc as an internal server, but it immediately fixes the error when initializing the connection, as it sends hard-coding commands in syntax that Composite does not support (for example SET ...).

The easiest way to get this to work, obviously, is to simply code directly against pyodbc. But before going this route, I would like to explore the possibility of writing a custom backend. I saw a couple of django-backend patterns written for non-relational backends. However, I could not find a similar pattern for relational databases. Is there such a thing? Any other recommendations?

Answer 1

I think the SQLite relational server is pretty simple, if you want to go this route, maybe see https://github.com/django/django/blob/master/django/db/backends/sqlite3/base.py