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 and for version 4.2 with python 3.11 only
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 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 bit-shift 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. - queryset iterator with chunk size
Warning If you have used another backend before
- this one uses
uniqueidentifier
field for UUIDField while others may have used nvarchar.
Installation
For django 4.2
pip install bitarray python-tds tds_django==4.2.0
For django 4.1
pip install bitarray python-tds tds_django==4.1.0
For django 4.0
pip install bitarray python-tds tds_django==4.0.0
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.2.1.tar.gz
(34.2 kB
view hashes)
Built Distribution
tds_django-4.2.1-py3-none-any.whl
(37.3 kB
view hashes)
Close
Hashes for tds_django-4.2.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1a6dcc58df9aaab12feed3c624aab9f052cdb66929b7d10c3ddbe653f16fd107 |
|
MD5 | da8229dedd5a4a7555b6b12814709bf8 |
|
BLAKE2b-256 | e4e24dfd6e621bd97e3c42c375ed4a3340f52fb3fb0c791b909ec4bedf156973 |