DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)
Project description
pymssql - DB-API interface to Microsoft SQL Server
A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server.
Detailed information on pymssql is available on the website:
New development is happening on GitHub at:
There is a Google Group for discussion at:
Getting started
Generally, you will want to install pymssql with:
pip install pymssql
Most of the times this should be all what’s needed.
Recent Changes
Version 2.2.0 - 2021-04-00 - Mikhail Terekhov
General
Add Python-3.9 to the build and test matrix.
Drop support for Python2 and Python3 < 3.6.
Use FreeTDS-1.2.18 for official wheels on PyPi.
Features
Support bulk copy (#279). Thanks to Simon.StJG (PR-689).
Wheels on PyPI link FreeTDS statically.
Wheels on PyPI linked against OpenSSL.
Convert pymssql to a package. Potential compatibility issue: projects using low level _mssql module need to import it from pymssql first.
Bug fixes
Fixed a deadlock caused by a missing release of GIL (#540), thanks to filip.stefanak (PR-541) and Juraj Bubniak (PR-683).
Prevents memory leak on login failure. Thanks to caogtaa and Simon.StJG (PR-690).
Fix check for TDS version (#652 and #669).
Documentation fixes. Thanks to Simon Biggs, Shane Kimble, Simon.StJG and Dale Evans.
Internals
Introduce script dev/build.py to build FreeTDS and pymssql wheels.
Simplify setup.py, introduce environment variables to select FreeTDS includes and libraries.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for pymssql-2.2.1.dev0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 51c67bcbf73fae9824b03ee14156472accadd135c259baa0b25b534c79ea98d4 |
|
MD5 | ede645c77f79dc0f1b9268ea2b25c19b |
|
BLAKE2b-256 | 83de5b6a1f543750f6217a53bb6f244c5fd9b37f850786551c8fc2fc12501ee5 |
Hashes for pymssql-2.2.1.dev0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bd1750fcbd16c34094b89eee4d9e5d627261dd98bd363c25209ea10e851dcb16 |
|
MD5 | 8adde6fb5947d9d82bc99c7e02fcae67 |
|
BLAKE2b-256 | 0cdeb7cefe363dbd1c86d6f88e1c041d7f6108440ef89c0ebb8e3b6f7e187cbc |
Hashes for pymssql-2.2.1.dev0-cp39-cp39-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 721ff49635f36ae3530123112b6cff6acb2c80e804d6d1ee62b37840088ec72c |
|
MD5 | 6c056358555758cea3465e257abe1a6b |
|
BLAKE2b-256 | 47b7461c04b8cdb645f4d2eb78e01bad9873dd1973c6cce793281c792bd2fef7 |
Hashes for pymssql-2.2.1.dev0-cp39-cp39-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 46ad0187164703dfa3ceec4ce80189786203ac03fe017d8f11e84c3affc94b76 |
|
MD5 | 5ab938f54ceb4513c2bfbf06455f2632 |
|
BLAKE2b-256 | b25602dbb3bdd9dbadf75a2085b6f6098f1ecb1e4a4852bd872d6fa9b2ebd7c2 |
Hashes for pymssql-2.2.1.dev0-cp39-cp39-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1e4d51f405ca0a788e03733b2dd49114cc26cf4a5d25d93dd15096ca436d95cc |
|
MD5 | f81a32dfc7e10f9f54e6ed6e878b1895 |
|
BLAKE2b-256 | 57f43eea9d812f10e808e4fb4e2737a973abfd785b85cf2638a0d87fe5e23a50 |
Hashes for pymssql-2.2.1.dev0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c09c957bc553bfd0b66a266566e57bb83fca19a709bcbc77871ac80abfc69520 |
|
MD5 | de3656d91128b10b525460ff86af3496 |
|
BLAKE2b-256 | ff27d52e52e34d0b6e1b3d02068f3caeac5ac0d79b64acb97027bb2190b10a0f |
Hashes for pymssql-2.2.1.dev0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9b904b25decf129b7138eed389b66f672acc3afc40a9e6ec00c4a1ffa5f80e79 |
|
MD5 | a5f033a5f1b557a9a2481f3432b35de7 |
|
BLAKE2b-256 | 43054e561341c2c797d85d808da73dfb554d6a0ffe97d9feb321036a552d305f |
Hashes for pymssql-2.2.1.dev0-cp38-cp38-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | be04e743c296b6838db13e3e4b4bb96da5f61079f28a833d2f5afba71ad9c41a |
|
MD5 | 6e43e4f75519415685b4697b8b3942a9 |
|
BLAKE2b-256 | f7937abe6aba36aa95e64dd386fcf4dddf7a8db173668e329e477479bc900317 |
Hashes for pymssql-2.2.1.dev0-cp38-cp38-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0246c41a0411160cfa2f579d8dd8f04a232913097d80dd6ac56c4a05c84b688e |
|
MD5 | 1500bc83af99b9ed145763b470e355e7 |
|
BLAKE2b-256 | e95eea802188bdf71c12b81194eb8cb70ec80cc6c40564e052d67164e8965e55 |
Hashes for pymssql-2.2.1.dev0-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ac4edbbd51627e37acc1c0e71cc60ed5fcce85993aaaa9d14521c1cd4b9f2a78 |
|
MD5 | 19b0b94e313300c015ec1218567f97f9 |
|
BLAKE2b-256 | 292e1080062ceb3db659df6d3108aaf0987c9117ad8cf4aa8b31f247d11d0f20 |
Hashes for pymssql-2.2.1.dev0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ebc9762a13cb87ab07fa6d72236e8adaefccc84cff189e8a4c45d41da346aa2a |
|
MD5 | 93d32938a74c64c53f35bf2291450b01 |
|
BLAKE2b-256 | aeba64455331ccbcfc9c3380292d408fe7e65596c151cfa97fb7a9ba332e228c |
Hashes for pymssql-2.2.1.dev0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7be1a766e9b09495a1371dbfca0db0cb72fd488735413a767e8c21a38168a41d |
|
MD5 | 80a79a2e4e102c5fd2fd25574ef5727a |
|
BLAKE2b-256 | 415b54ee55d356fa7e36b3e51dc171df7c4e46b616d0a09a0e79800c8b9e7eed |
Hashes for pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | defa7832ad6c02c21a8a2b5c606e73aa3eb85a734634120e08579cbccfd64095 |
|
MD5 | 7e44ff3958900894c28ea2203fa4c683 |
|
BLAKE2b-256 | 78431d9b84316d3c0604720ba14fba49282a2805b475170b09b9e63a410e9320 |
Hashes for pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fe0fdb0802e7560777215adc86a77c86e26660d1f442ff7b0f031838e07ef167 |
|
MD5 | 25fadc9bf42b2fcd9501fa1416a0bbbb |
|
BLAKE2b-256 | 3deeebbb50a3944be248b75897eca0ddfcf3339dd41fbba5389c62798db2c93f |
Hashes for pymssql-2.2.1.dev0-cp37-cp37m-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dae7a2c84c7eb417ec6d8ece5ad9d7bdf37ccacafff2793e35edf7cb7279d7c0 |
|
MD5 | e272559c8f89b429b7db90ab2a9d3c92 |
|
BLAKE2b-256 | f380dbec1afa4fede5578c9046802364d7b38ea2233414e9c8e28d56a70c7a8d |
Hashes for pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 20dd606bf3e488e53693b589263e7f8066d58d63968e5aec290c9569792ff6b6 |
|
MD5 | 1b600889bb9d9b394e2047b1a96d4bf9 |
|
BLAKE2b-256 | fb5bce3bae7ef6dd5e37befa1836c9130223d90ebc224299b8c6bd2efab86f1b |
Hashes for pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36a27a6714300add6c076774d2b33daf189723ad247070c48473019c8ff7a8b8 |
|
MD5 | 5a73e57c5e6d2b5d5aefc70f5dda28e5 |
|
BLAKE2b-256 | 9fc44773c634de490ee0a074b254adfd4c1001ffc1a029e314686229719e0d74 |