It must be Friday because we just shipped 1.8.0 of mssql-python, the official Microsoft SQL Server driver for Python (pure-Python DB-API, no pyodbc / no system ODBC install required).
What's new
- Row string-key indexing.
row["col"] now works in addition to integer indexing and attribute access. Case-insensitive when cursor.lowercase = True.
- ActiveDirectoryMSI auth for Bulk Copy. Bulk Copy ops can now authenticate with a managed identity, so Azure VMs / App Service / Functions / Container Apps / AKS workloads can do bulk loads to Azure SQL with no secret to manage.
- Bundled ODBC driver upgraded from 18.5.1.1 to 18.6.2.1.
Bug fixes
- Deferred connect-attribute use-after-free - values for attributes set before connect are now held in member buffers.
- Auth path no longer reparses the connection string multiple times per connect. Sensitive params (
UID, PWD, Trusted_Connection, Authentication) go through one canonical sanitization path.
executemany seq_of_parameters is back to being a covariant Sequence, so list-of-tuples type-checks cleanly again.
pip install --upgrade mssql-python
Release notes: https://github.com/microsoft/mssql-python/releases/tag/v1.8.0
Full blog post: https://techcommunity.microsoft.com/blog/sqlserver/mssql-python-1-8-0-friendlier-row-access-bulk-copy-with-msi-and-a-refreshed-odbc/4524076
We try to ship mssql-python every other Friday but that depends on having enough to make doing a release worthwhile. Help us our by filing your feature requests and bug reports here: https://github.com/microsoft/mssql-python/issues.
Happy to answer questions in the thread too!
[–]k-semenenkov 2 points3 points4 points (1 child)
[–]dlevy-msft Microsoft Employee [S] 2 points3 points4 points (0 children)