TerminusDB backend for Django

💕

What is Django and why it is used?

Why do we do it?

• Using TerminusDB without learning WOQL
• Easier migration from other DB to TerminusDB for Django users
• Capture the Python (especially Django) communities
• MongoDB has it

Levels of Django ORM

• Model
• Manager
• QuerySet
• Query
• Expression
• SQLComplier
• Database backend

But first, we need to follow PEP249 more or less

(back to the 4 Miro tickets on Thursday)

To Do for PEP249

• connect object
• error handeling
• cursor object
• type conversion

https://www.python.org/dev/peps/pep-0249/

Watch this talk:

https://youtu.be/OCq2eUmrCfI

Do we mess with the SQLComplier?

The ​Django-nonrel branch of Django already provides support for NoSQL and it requires only minimal changes to Django's ORM.

https://code.djangoproject.com/wiki/NoSqlSupport#Django-nonrel

Django-nonrel branch

https://github.com/django-nonrel

Talk in 2012: https://youtu.be/akAtm7SnzWg

Toolbox for writing non-rel backends

https://github.com/django-nonrel/djangotoolbox

For example, it provides class object to override the SQLComplier:

https://github.com/django-nonrel/djangotoolbox/blob/7e2c47e2ab5ee98d0c0f47c5ccce08e75feda48a/djangotoolbox/db/basecompiler.py#L376

Writing a non-rel Django backend: https://www.allbuttonspressed.com/blog/django/2010/04/Writing-a-non-relational-Django-backend

Example of non-rel complier

MongoDB: https://github.com/django-nonrel/mongodb-engine/blob/master/django_mongodb_engine/compiler.py

Big steps:

1.  4 ticket for PEP249
2. Use the non-rel toolbox to override SQLComplier etc.
3. Make sure Django commands still works e.g. migrate