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.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

pip install git+https://github.com/red-soft-ru/django-reddatabase.git

Manual Installation

git clone https://github.com/red-soft-ru/django-reddatabase.git

cd django-reddatabase

sudo python setup.py install

Configuration

Modify your setting.py

DATABASES = {
    'default': {
        'ENGINE' : 'django_reddatabase',
        '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