SQL Server 3rd Party Backend for Django v1.0 Released

Published Aug 17 2021 09:00 AM 1,985 Views
Microsoft

We're officially announcing the release of mssql-django v1.0 as an open source project!

 

At Microsoft we've heard from the community loud and clear - SQL Server is the biggest enterprise backend not yet fully supported in Django.

 

That's about to change.

 

This project picks up where previous open source projects have left off. We began with a series of preview releases in February 2021, and we're pleased to officially bring Microsoft support to SQL Server and Azure SQL DB with this version's official release.

 

Our goal is to provide a Microsoft-backed 3rd party backend for Django, while leaving open the possibility of adding MSSQL as a Django core backend in the future (depending on what turns out to be the best for the community).

 

Get started by visiting the open source project on the Github repository. Information about the project can be found in the Github wiki including Getting-Started instructions. After installing dependencies, configuring Django is achieved by updating the settings.py file:

 

 

DATABASES = {
    'default': {
        'ENGINE': 'mssql',
        'NAME': 'mydb',
        'USER': 'user@myserver',
        'PASSWORD': 'password',
        'HOST': 'myserver.database.windows.net',
        'PORT': '',

        'OPTIONS': {
            'driver': 'ODBC Driver 17 for SQL Server',
        },
    },
}

# set this to False if you want to turn off pyodbc's connection pooling
DATABASE_CONNECTION_POOLING = False

 

 

We encourage you to get involved by asking questions or contributing to the project in Github. We are active in the repo on a daily basis and look forward to collaborating!

 

Big thanks to everyone who has contributed to this open source project. This includes individuals and groups such the django-pyodbc developers, Michiya Takahashi and ES Solutions AB.

 

Happy Coding,
Team Microsoft

%3CLINGO-SUB%20id%3D%22lingo-sub-2654239%22%20slang%3D%22en-US%22%3ESQL%20Server%203rd%20Party%20Backend%20for%20Django%20v1.0%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654239%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20officially%20announcing%20the%20release%20of%20mssql-django%20v1.0%20as%20an%20open%20source%20project!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAt%20Microsoft%20we've%20heard%20from%20the%20community%20loud%20and%20clear%20-%20SQL%20Server%20is%20the%20biggest%20enterprise%20backend%20not%20yet%20fully%20supported%20in%20Django.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20about%20to%20change.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20project%20picks%20up%20where%20previous%20open%20source%20projects%20have%20left%20off.%20We%20began%20with%20a%20series%20of%20preview%20releases%20in%20February%202021%2C%20and%20we're%20pleased%20to%20officially%20bring%20Microsoft%20support%20to%20SQL%20Server%20and%20Azure%20SQL%20DB%20with%20this%20version's%20official%20release.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOur%20goal%20is%20to%20provide%20a%20Microsoft-backed%203rd%20party%20backend%20for%20Django%2C%20while%20leaving%20open%20the%20possibility%20of%20adding%20MSSQL%20as%20a%20Django%20core%20backend%20in%20the%20future%20(depending%20on%20what%20turns%20out%20to%20be%20the%20best%20for%20the%20community).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGet%20started%20by%20visiting%20the%20open%20source%20project%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-django%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGithub%20repository%3C%2FA%3E.%20Information%20about%20the%20project%20can%20be%20found%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-django%2Fwiki%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGithub%20wiki%3C%2FA%3E%20including%20Getting-Started%20instructions.%20After%20installing%20dependencies%2C%20configuring%20Django%20is%20achieved%20by%20updating%20the%20settings.py%20file%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-python%22%3E%3CCODE%3EDATABASES%20%3D%20%7B%0A%20%20%20%20'default'%3A%20%7B%0A%20%20%20%20%20%20%20%20'ENGINE'%3A%20'mssql'%2C%0A%20%20%20%20%20%20%20%20'NAME'%3A%20'mydb'%2C%0A%20%20%20%20%20%20%20%20'USER'%3A%20'user%40myserver'%2C%0A%20%20%20%20%20%20%20%20'PASSWORD'%3A%20'password'%2C%0A%20%20%20%20%20%20%20%20'HOST'%3A%20'myserver.database.windows.net'%2C%0A%20%20%20%20%20%20%20%20'PORT'%3A%20''%2C%0A%0A%20%20%20%20%20%20%20%20'OPTIONS'%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20'driver'%3A%20'ODBC%20Driver%2017%20for%20SQL%20Server'%2C%0A%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%7D%2C%0A%7D%0A%0A%23%20set%20this%20to%20False%20if%20you%20want%20to%20turn%20off%20pyodbc's%20connection%20pooling%0ADATABASE_CONNECTION_POOLING%20%3D%20False%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20encourage%20you%20to%20get%20involved%20by%20asking%20questions%20or%20contributing%20to%20the%20project%20in%20Github.%20We%20are%20active%20in%20the%20repo%20on%20a%20daily%20basis%20and%20look%20forward%20to%20collaborating!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBig%20thanks%20to%20everyone%20who%20has%20contributed%20to%20this%20open%20source%20project.%20This%20includes%20individuals%20and%20groups%20such%20the%20django-pyodbc%20developers%2C%20Michiya%20Takahashi%20and%20ES%20Solutions%20AB.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHappy%20Coding%2C%3CBR%20%2F%3ETeam%20Microsoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2654239%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20officially%20announcing%20the%20release%20of%20mssql-django%20v1.0%20as%20an%20open%20source%20project!%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2654239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Aug 16 2021 04:43 PM
Updated by: