v0.5.0-preview

Release Notes

This is the public preview release of the Microsoft open-source mssql-python driver!

New features

• MacOS Support: The mssql-python driver now supports macOS on ARM-based systems, enabling seamless development on Apple Silicon (M-series) devices. This milestone strengthens our cross-platform capabilities—and we’re just getting started. Linux support is on the horizon!
• Connection Pooling: We've introduced a robust and configurable connection pooling system designed to significantly enhance performance and optimize resource utilization. This feature ensures more efficient management of database connections, especially under high-load scenarios

Issues Fixed

• Enhanced logging has been implemented, particularly for connection strings, where sensitive information such as user IDs and passwords is now obfuscated in error log files to ensure security and compliance.

v0.1.6-alpha

Release Notes

This is the second public alpha release of the Microsoft open-source mssql-python driver!

New features

• Added support for ARM64 (Windows only)
  Support for (macOS and Linux support is coming soon)

• Added support for Microsoft Entra ID Integrated authentication and access tokens

• Backward compatibility with older python versions (>=3.10)

• Introduced a new SqlHandle wrapper class in ddbc_bindings.cpp to manage the lifecycle of SQL handles, including a free() method for explicit resource cleanup. This avoids nondeterministic crashes during garbage collection or shutdown. Issue# #16

Issues Fixed

• EntraID support using mssql-auth.dll. The file mssql-auth.dll is a dynamic link library introduced as part of Microsoft's newer authentication infrastructure for SQL Server drivers, particularly replacing the older ADAL (Azure Active Directory Authentication Library). It is used to support Microsoft Entra ID (formerly Azure AD) authentication.

• A minor change to the mssql_python/type.py file. The change ensures compatibility by replacing datetime.UTC with datetime.timezone.utc in the TimestampFromTicks function. This was brought because of backward compatibility with python version 3.10.

Stay tuned for upcoming improvements and updates!

v0.1.5-alpha

This is the first public alpha release of the Microsoft open-source mssql-python driver!

Supported Platforms: Windows only (macOS and Linux support is coming soon)

Support for Microsoft Entra ID Authentication

DBAPI v2.0 Compliance: Fully compliant with the DB API 2.0 specification. Key aspects of DBAPI v2.0 compliance include:

• Connection Objects: Establishing and managing connections to the database.
• Cursor Objects: Executing SQL commands and retrieving results.
• Transaction Management: Supporting commit and rollback operations to ensure data integrity.
• Error Handling: Providing a consistent set of exceptions for handling database errors.
• Parameter Substitution: Allowing the use of placeholders in SQL queries to prevent SQL injection attacks.

Stay tuned for upcoming improvements and updates!