Skip to main content

DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)

Project description

pymssql - DB-API interface to Microsoft SQL Server

https://github.com/pymssql/pymssql/workflows/Linux/badge.svg https://github.com/pymssql/pymssql/workflows/macOS/badge.svg https://github.com/pymssql/pymssql/workflows/Windows/badge.svg http://img.shields.io/pypi/dm/pymssql.svg http://img.shields.io/pypi/v/pymssql.svg

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:

pymssql.readthedocs.io

New development is happening on GitHub at:

github.com/pymssql/pymssql

There is a Google Group for discussion at:

groups.google.com

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pymssql-2.2.1.dev0.tar.gz (170.4 kB view details)

Uploaded Source

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

pymssql-2.2.1.dev0-cp39-cp39-win_amd64.whl (1.5 MB view details)

Uploaded CPython 3.9Windows x86-64

pymssql-2.2.1.dev0-cp39-cp39-win32.whl (1.3 MB view details)

Uploaded CPython 3.9Windows x86

pymssql-2.2.1.dev0-cp39-cp39-manylinux1_x86_64.whl (2.6 MB view details)

Uploaded CPython 3.9

pymssql-2.2.1.dev0-cp39-cp39-manylinux1_i686.whl (2.5 MB view details)

Uploaded CPython 3.9

pymssql-2.2.1.dev0-cp39-cp39-macosx_10_14_x86_64.whl (515.9 kB view details)

Uploaded CPython 3.9macOS 10.14+ x86-64

pymssql-2.2.1.dev0-cp38-cp38-win_amd64.whl (1.5 MB view details)

Uploaded CPython 3.8Windows x86-64

pymssql-2.2.1.dev0-cp38-cp38-win32.whl (1.3 MB view details)

Uploaded CPython 3.8Windows x86

pymssql-2.2.1.dev0-cp38-cp38-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 3.8

pymssql-2.2.1.dev0-cp38-cp38-manylinux1_i686.whl (2.6 MB view details)

Uploaded CPython 3.8

pymssql-2.2.1.dev0-cp38-cp38-macosx_10_14_x86_64.whl (513.2 kB view details)

Uploaded CPython 3.8macOS 10.14+ x86-64

pymssql-2.2.1.dev0-cp37-cp37m-win_amd64.whl (1.5 MB view details)

Uploaded CPython 3.7mWindows x86-64

pymssql-2.2.1.dev0-cp37-cp37m-win32.whl (1.3 MB view details)

Uploaded CPython 3.7mWindows x86

pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_x86_64.whl (2.6 MB view details)

Uploaded CPython 3.7m

pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_i686.whl (2.5 MB view details)

Uploaded CPython 3.7m

pymssql-2.2.1.dev0-cp37-cp37m-macosx_10_14_x86_64.whl (506.6 kB view details)

Uploaded CPython 3.7mmacOS 10.14+ x86-64

pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_x86_64.whl (2.6 MB view details)

Uploaded CPython 3.6m

pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_i686.whl (2.5 MB view details)

Uploaded CPython 3.6m

File details

Details for the file pymssql-2.2.1.dev0.tar.gz.

File metadata

  • Download URL: pymssql-2.2.1.dev0.tar.gz
  • Upload date:
  • Size: 170.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0.tar.gz
Algorithm Hash digest
SHA256 a90129b25a1bb3c723953010167f3c6f039070d9679d9189825e11de1e1ab3c9
MD5 d369ebb4492fe11ae23fa3be7fb022f8
BLAKE2b-256 46a6ccd2cde8592829f70b5bceb4386f48d5b3cc81a1520e8e32806d1142aafb

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp39-cp39-win_amd64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 1.5 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 51c67bcbf73fae9824b03ee14156472accadd135c259baa0b25b534c79ea98d4
MD5 ede645c77f79dc0f1b9268ea2b25c19b
BLAKE2b-256 83de5b6a1f543750f6217a53bb6f244c5fd9b37f850786551c8fc2fc12501ee5

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp39-cp39-win32.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp39-cp39-win32.whl
  • Upload date:
  • Size: 1.3 MB
  • Tags: CPython 3.9, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 bd1750fcbd16c34094b89eee4d9e5d627261dd98bd363c25209ea10e851dcb16
MD5 8adde6fb5947d9d82bc99c7e02fcae67
BLAKE2b-256 0cdeb7cefe363dbd1c86d6f88e1c041d7f6108440ef89c0ebb8e3b6f7e187cbc

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp39-cp39-manylinux1_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp39-cp39-manylinux1_x86_64.whl
  • Upload date:
  • Size: 2.6 MB
  • Tags: CPython 3.9
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp39-cp39-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 721ff49635f36ae3530123112b6cff6acb2c80e804d6d1ee62b37840088ec72c
MD5 6c056358555758cea3465e257abe1a6b
BLAKE2b-256 47b7461c04b8cdb645f4d2eb78e01bad9873dd1973c6cce793281c792bd2fef7

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp39-cp39-manylinux1_i686.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp39-cp39-manylinux1_i686.whl
  • Upload date:
  • Size: 2.5 MB
  • Tags: CPython 3.9
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp39-cp39-manylinux1_i686.whl
Algorithm Hash digest
SHA256 46ad0187164703dfa3ceec4ce80189786203ac03fe017d8f11e84c3affc94b76
MD5 5ab938f54ceb4513c2bfbf06455f2632
BLAKE2b-256 b25602dbb3bdd9dbadf75a2085b6f6098f1ecb1e4a4852bd872d6fa9b2ebd7c2

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp39-cp39-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp39-cp39-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 515.9 kB
  • Tags: CPython 3.9, macOS 10.14+ x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

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

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp38-cp38-win_amd64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 1.5 MB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.8.8

File hashes

Hashes for pymssql-2.2.1.dev0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 c09c957bc553bfd0b66a266566e57bb83fca19a709bcbc77871ac80abfc69520
MD5 de3656d91128b10b525460ff86af3496
BLAKE2b-256 ff27d52e52e34d0b6e1b3d02068f3caeac5ac0d79b64acb97027bb2190b10a0f

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp38-cp38-win32.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp38-cp38-win32.whl
  • Upload date:
  • Size: 1.3 MB
  • Tags: CPython 3.8, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.8.8

File hashes

Hashes for pymssql-2.2.1.dev0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 9b904b25decf129b7138eed389b66f672acc3afc40a9e6ec00c4a1ffa5f80e79
MD5 a5f033a5f1b557a9a2481f3432b35de7
BLAKE2b-256 43054e561341c2c797d85d808da73dfb554d6a0ffe97d9feb321036a552d305f

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp38-cp38-manylinux1_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp38-cp38-manylinux1_x86_64.whl
  • Upload date:
  • Size: 2.7 MB
  • Tags: CPython 3.8
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp38-cp38-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 be04e743c296b6838db13e3e4b4bb96da5f61079f28a833d2f5afba71ad9c41a
MD5 6e43e4f75519415685b4697b8b3942a9
BLAKE2b-256 f7937abe6aba36aa95e64dd386fcf4dddf7a8db173668e329e477479bc900317

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp38-cp38-manylinux1_i686.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp38-cp38-manylinux1_i686.whl
  • Upload date:
  • Size: 2.6 MB
  • Tags: CPython 3.8
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp38-cp38-manylinux1_i686.whl
Algorithm Hash digest
SHA256 0246c41a0411160cfa2f579d8dd8f04a232913097d80dd6ac56c4a05c84b688e
MD5 1500bc83af99b9ed145763b470e355e7
BLAKE2b-256 e95eea802188bdf71c12b81194eb8cb70ec80cc6c40564e052d67164e8965e55

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp38-cp38-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp38-cp38-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 513.2 kB
  • Tags: CPython 3.8, macOS 10.14+ x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.8.8

File hashes

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

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp37-cp37m-win_amd64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 1.5 MB
  • Tags: CPython 3.7m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.7.9

File hashes

Hashes for pymssql-2.2.1.dev0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 ebc9762a13cb87ab07fa6d72236e8adaefccc84cff189e8a4c45d41da346aa2a
MD5 93d32938a74c64c53f35bf2291450b01
BLAKE2b-256 aeba64455331ccbcfc9c3380292d408fe7e65596c151cfa97fb7a9ba332e228c

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp37-cp37m-win32.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 1.3 MB
  • Tags: CPython 3.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.7.9

File hashes

Hashes for pymssql-2.2.1.dev0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 7be1a766e9b09495a1371dbfca0db0cb72fd488735413a767e8c21a38168a41d
MD5 80a79a2e4e102c5fd2fd25574ef5727a
BLAKE2b-256 415b54ee55d356fa7e36b3e51dc171df7c4e46b616d0a09a0e79800c8b9e7eed

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_x86_64.whl
  • Upload date:
  • Size: 2.6 MB
  • Tags: CPython 3.7m
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 defa7832ad6c02c21a8a2b5c606e73aa3eb85a734634120e08579cbccfd64095
MD5 7e44ff3958900894c28ea2203fa4c683
BLAKE2b-256 78431d9b84316d3c0604720ba14fba49282a2805b475170b09b9e63a410e9320

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_i686.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_i686.whl
  • Upload date:
  • Size: 2.5 MB
  • Tags: CPython 3.7m
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp37-cp37m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 fe0fdb0802e7560777215adc86a77c86e26660d1f442ff7b0f031838e07ef167
MD5 25fadc9bf42b2fcd9501fa1416a0bbbb
BLAKE2b-256 3deeebbb50a3944be248b75897eca0ddfcf3339dd41fbba5389c62798db2c93f

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp37-cp37m-macosx_10_14_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp37-cp37m-macosx_10_14_x86_64.whl
  • Upload date:
  • Size: 506.6 kB
  • Tags: CPython 3.7m, macOS 10.14+ x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.7.10

File hashes

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

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_x86_64.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_x86_64.whl
  • Upload date:
  • Size: 2.6 MB
  • Tags: CPython 3.6m
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 20dd606bf3e488e53693b589263e7f8066d58d63968e5aec290c9569792ff6b6
MD5 1b600889bb9d9b394e2047b1a96d4bf9
BLAKE2b-256 fb5bce3bae7ef6dd5e37befa1836c9130223d90ebc224299b8c6bd2efab86f1b

See more details on using hashes here.

File details

Details for the file pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_i686.whl.

File metadata

  • Download URL: pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_i686.whl
  • Upload date:
  • Size: 2.5 MB
  • Tags: CPython 3.6m
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.2

File hashes

Hashes for pymssql-2.2.1.dev0-cp36-cp36m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 36a27a6714300add6c076774d2b33daf189723ad247070c48473019c8ff7a8b8
MD5 5a73e57c5e6d2b5d5aefc70f5dda28e5
BLAKE2b-256 9fc44773c634de490ee0a074b254adfd4c1001ffc1a029e314686229719e0d74

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page