pymssql A free and simple database interface to MS-SQL for Python
Download

pymssql Ranking & Summary

pymssql Tags

interface database database interface database access MS-SQL interface MS-SQL

pymssql Description

A free and simple database interface to MS-SQL for Python pymssql is a free and open source tool that provides developers access to Microsoft SQL Servers from Python scripts.pymssql is cross-platform and has been tested on Mac OS X, Linux, *BSD, Solaris, and Windows. Requirements: · Python What's New in This Release: · fixed severe bug introduced in 1.0.0 that caused some queries to be truncated or overwritten with binary garbage - many thanks to Igor Nazarenko who found the exact cause of the bug, · fixed bug - if a query batch contained DECLARE or possibly some other T-SQL statements, query results were not available (DECLARE yielded additional result with no columns) - thanks Corey Bertram and Wes McKinney, · fixed incompatibility - a % character in query without parameters is treated like any other character; it gains its special meaning as a formatting specifier only if any arguments are given. This allows for straightforward queries similar to the following: SELECT * FROM sysobjects WHERE name LIKE 's%', · updated Nagios plugin - thanks Josselin Mouette for the patch, · pymssql on Linux/*NIX understands BIGINT natively - thanks Alexandr Zamaraev for the patch (on Windows it is returned as SQLNUMERIC data type by the DB Library, which is converted to Python Decimal value), · new feature: pymssql.connect() method understands new argument: as_dict - which allows to return rows as dictionaries instead of tuples - thanks Daniel Watrous for the idea and draft patch, · new feature: pymssql.connect() and _mssql.connect() methods understand new argument: max_conn - which helps increase the default 25 concurrent connections limit - thanks Daniel Watrous for the idea and draft patch, · important doc update: documented that with the technology pymssql currently uses (DB Library for C), it is not possible to read or write BLOBs longer than 4096 bytes, · further webpage changes to improve access to information.

pymssql Related Software