pymssqlA free and simple database interface to MS-SQL for Python | |
Download |
pymssql Ranking & Summary
Advertisement
- License:
- GPL
- Price:
- FREE
- Publisher Name:
- Andrzej Kukula
- Publisher web site:
- Operating Systems:
- Mac OS X
- File Size:
- 174 KB
pymssql Tags
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