Mssql Django

screenshot of Mssql Django

The Microsoft Django backend for SQL Server provides a connectivity layer for Django on SQL Server or Azure SQL DB.

Overview

The MSSQL-Django backend project offers a robust and flexible database connectivity solution for Django developers working with Microsoft SQL Server and Azure SQL Database. As a fork of the django-mssql-backend, this tool aims to enhance seamless integration while maintaining compatibility with multiple Django versions. It's a testament to community collaboration, with contributions from various developers, making it a reliable choice for enterprise-level applications.

This backend not only simplifies the setup process, but it also expands the capabilities of Django in handling SQL Server databases, providing enhanced features and compatibility that appeal to both seasoned developers and newcomers alike.

Features

  • Django Version Support: Fully supports Django versions 3.2 through 5.2, with varying levels of compatibility for specific versions.
  • Production Ready: Offers full production support for Django 5.0 and below, with minor limitations for 5.1. Version 5.2 comes with enhanced SQL Server compatibility.
  • Thorough Testing: Successfully tested on Microsoft SQL Server versions 2016 to 2022, ensuring reliability across a range of server environments.
  • Enhanced Compatibility: Automatic schema creation coupled with improved identifier quoting enhances the overall SQL Server compatibility for more efficient database operations.
  • ODBC Driver Compatibility: Works seamlessly with Microsoft ODBC Driver, SQL Server Native Client, and FreeTDS ODBC drivers, allowing flexible integration options.
  • Custom Configuration Options: Provides a comprehensive set of database-level settings in the DATABASES dictionary, allowing for high customization in connection parameters.
  • Support for Access Tokens: Allows for secure access using tokens fetched from Azure credentials, catering to modern security requirements.
  • Testing Features: Comes equipped with specific settings in the TEST dictionary to streamline the testing process during development.