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] http://pypi.python.org/pypi/fdb/

Requirements

• Python 3.x

• Django 2.2.x

• fdb (http://pypi.python.org/pypi/fdb/)

Installation

Using pip

pip install django-firebird

From repository

git clone git://github.com/maxirobaina/django-firebird.git

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 git://github.com/maxirobaina/django-firebird.git

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:

https://github.com/maxirobaina/django-firebird

We also have a mailing list:

http://groups.google.com/group/django-firebird-dev