django-firebird

Firebird SQL backend for django

Repo Note: The master branch is an in development version of django-firebird. This may be substantially different from the latest release of django-firebird

This version of django-firebird is working with fbd [1], therefore it will work only with firebird 2.x and later. The stable version corresponds with django 2.2 and live into stable/2.2.x branch. The current master branch of this repository is being developed under django 3.0.x. For previous Django stable version check the branch list of this repository. fbd is the official stable python-firebird driver, also it has support for python 3.

[1]

Requirements

> - Python 3.x > - Django 2.2.x > - fdb ()

Installation

Using pip

> pip install django-firebird

From repository

> git clone > > cd django-firebird > > sudo python setup.py install

Manual Installation

Instructions for Ubuntu/Debian I assume you have installed django from source with python setup.py install

> cd /usr/local/lib/python3.8/dist-packages > > sudo git clone > > sudo ln -s django-firebird/firebird firebird > > cd /usr/local/lib/python3.8/dist-packages/django/db/backends > > sudo ln -s > /usr/local/lib/python3.8/dist-packages/django-firebird/firebird

Configuration

Modify your setting.py :

DATABASES = {
    'default': {
        'ENGINE' : 'firebird',
        'NAME' : '/var/lib/firebird/3.0/data/django_firebird.fdb', # Path to database or db alias
        'USER' : 'SYSDBA',           # Your db user
        'PASSWORD' : '*****',    # db user password
        'HOST' : '127.0.0.1',        # Your host machine
        'PORT' : '3050',             # If is empty, use default 3050
        #'OPTIONS' : {'charset':'ISO8859_1'}
    }
}

Known bugs and issues

• Some database migrations doesn't work by default. Sometimes is better make intermediate migrations for solve problems.
• Some Query Expressions doesn't work by default. We need to make some workaround, ie: Use Cast().
• Combined duration expressions need more research. No all combination of expressions works.

Contributing

Code and issues is in GitHub:

>

We also have a mailing list:

>