microsoft/mssql-python v0.11.0-preview

on GitHub

Release Notes - Version 0.11.0

Features

• Database Metadata & Catalog APIs (#201, #192)

  What changed: Added comprehensive getInfo() method for database information retrieval and extensive metadata APIs including getTypeInfo(), procedures(), foreignKeys(), primaryKeys(), columns(), statistics(), rowIdColumns() and, rowVerColumns().
  Who benefits: Developers building database introspection tools and applications requiring schema discovery
  Impact: Complete database metadata access and improved schema management capabilities

• Advanced Parameter Management (#192)

  What changed: Implemented setinputsizes() method with SQL type constants export and enhanced parameter validation through the SQLTypes class
  Who benefits: Applications requiring precise parameter type control and validation
  Impact: Better performance and type safety in parameterized queries

• Connection-Level Execute & BatchExecute (#189)

  What changed: Added execute() & batchexecute() method directly to Connection class for simplified & faster query execution
  Who benefits: Developers seeking streamlined database operations without explicit cursor management
  Impact: More convenient & fast API for simple query operations

• Output Data Conversion System (#190)

  What changed: Introduced flexible output converter system with add_output_converter(), get_output_converter(), remove_output_converter(), and clear_output_converters() methods
  Who benefits: Applications requiring custom data type transformations during result fetching
  Impact: Customizable data processing pipeline for specialized use cases

• Global Configuration APIs (#188, #187)

  What changed: Added getDecimalSeperator(), setDecimalSeperator() global functions and lowercase support for global variables
  Who benefits: Applications requiring locale-specific decimal formatting and configuration management
  Impact: Enhanced internationalization and global configuration control

• Connection Timeout Control & Searchescape (#191)

  What changed: Added timeout & searchescape attribute for connection-level timeout & escape management
  Who benefits: Applications requiring fine-grained connection timeout & escaping control
  Impact: Better connection reliability and timeout handling

Improvements

• Large Binary Data Streaming (#232, #231)

  What changed: Enhanced VARBINARY(MAX) streaming support in all fetch operations with improved chunked retrieval and LOB handling
  Who benefits: Applications processing large binary objects like images, documents, and media files
  Impact: Efficient memory usage and reliable handling of large binary data

• Money Data Type Support (#230)

  What changed: Added comprehensive support for SQL Server MONEY and SMALLMONEY types with proper boundary value handling and decimal conversion
  Who benefits: Financial applications requiring precise monetary calculations
  Impact: Native support for SQL Server financial data types with accurate precision

• VARCHAR(MAX) Fetch Streaming (#219)

  What changed: Implemented streaming support for large text columns in fetchone() operations
  Who benefits: Applications handling large text content exceeding standard buffer limits
  Impact: Improved memory efficiency for large text data retrieval

Bug Fixes

• Parameter Type Inference (#215)

  What changed: Improved parameter type inference for batch operations with accurate integer range-based type selection
  Who benefits: Applications using executemany with varied data ranges
  Impact: More accurate SQL type mapping and better performance in batch operations

This release significantly enhances database introspection capabilities, streaming performance for large data, and provides comprehensive metadata access while maintaining backward compatibility.