Django backend for SQL Server using tds
Project description
SQL Server backend for Django >=3.2
- django 4
- django 3.2 (pypi package version 0.1)
- tested and used with SQL Server 2017
Warning
- There is an official package supported by microsoft, microsoft/mssql-django.
- This package does not need pyodbc nor the microsoft odbc driver, only pytds.
- This passes about 15000 tests from the django test suite but I personally use the django ORM mostly in a basic way and don't use most of the features.
Requirements
-
optional:
- bitarray, recommended by python-tds for performance
- for regex support you need to compile
clr/django_clr.cs
and install the resulting assembly or read and then run thetds_django/sql/clr.sql
script. - for date "math" as well as bitshift operations you need to read and run the
tds_django/sql/init.sql
script.
Unsupported
- JSON
- foreign keys to a nullable field (limitation of SQL Server)
- feel free to read
tds_django/features.py
for more details.
Warning If you have used another backend before
- this one uses
uniqueidentifier
field for UUIDField while others may have used nvarchar.
Installation
pip install bitarray python-tds tds_django
For django 3.2
pip install bitarray python-tds tds_django==0.1
settings.DATABASES
DATABASES = {
'default': {
'ENGINE': 'tds_django',
'HOST': 'localhost',
'PORT': '1433',
'NAME': '<db_name>',
'USER': '<db_user>',
'PASSWORD': '<db_password>',
},
}
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
tds-django-4.0.0.tar.gz
(32.8 kB
view hashes)
Built Distribution
tds_django-4.0.0-py3-none-any.whl
(36.0 kB
view hashes)
Close
Hashes for tds_django-4.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0bd17338c89ef7e088d379998ac25c17123cd237137bbe1032d0168aa1aaa5f2 |
|
MD5 | 6d2554c2e5c4ac63b45b12febacbedce |
|
BLAKE2b-256 | 53fc596ea35ee0d619f18bbab8e0260d8cd067c42078fbd03a86525a4f4fbae7 |