github microsoft/mssql-python v0.8.0-preview

latest releases: v0.9.0-preview, v0.8.1-preview
pre-releaseone month ago

Release Notes

Features

  • Authentication Module Added: (#135)
    What changed:
    A new authentication module was introduced, supporting Azure Active Directory authentication types: ActiveDirectoryInteractive for Mac and Linux, ActiveDirectoryDeviceCode, and ActiveDirectoryDefault.
    Who benefits:
    Developers integrating MSSQL with Azure services. Users requiring secure and flexible authentication options.
    Impact:
    Enables secure and varied authentication workflows for cloud-based environments.Simplifies integration with Azure AD, reducing custom code and setup.

Improvements

  • Batch Execution Refactor: (#138)
    What changed:
    Refactored Python executemany and C++ bindings to use column-wise parameter binding for batched SQL execution. Added helper functions for buffer allocation and exposed a new SQLExecuteMany method.
    Who benefits:
    Data engineers and developers running bulk operations.
    Impact:
    Faster, more efficient execution of bulk SQL operations.

  • Logging System Overhaul: (#137)
    What changed:
    Replaced the global logging flag with a singleton LoggingManager, added dynamic logger configuration, sanitized sensitive information in logs, and improved Python exception handling in C++ logging.
    Who benefits:
    Teams monitoring and debugging connections and application behavior.
    Impact:
    Improved security and traceability in logs, reducing risk of exposing sensitive information and making error diagnosis easier.

  • Row Object String Representation: (#136)
    What changed:
    Improved the Row class by adding a str method and updating repr for more user-friendly output and better debugging.
    Who benefits:
    Developers and testers interacting with row data.
    Impact:
    Easier debugging and more readable outputs, streamlining development and troubleshooting.

Don't miss a new mssql-python release

NewReleases is sending notifications on new releases.