pymssql 2.2.8

pip install pymssql==2.2.8

Newer version available (2.3.7)

Released: Jul 30, 2023

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

Navigation

Project description
Release history
Download files

Verified details

These details have been verified by PyPI

Maintainers

termim

Unverified details

These details have not been verified by PyPI

Project links

Changelog
Documentation
Source

Classifiers

Development Status
- 5 - Production/Stable
Intended Audience
- Developers
License
- OSI Approved :: GNU Library or Lesser General Public License (LGPL)
Operating System
Programming Language
Topic

Report project as malware

Project description
Project details
Release history
Download files

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

pymssql wheels are available from PyPi. To install it run:

pip install -U pip
pip install pymssql

Most of the times this should be all what’s needed. The official pymssql wheels bundle a static copy of FreeTDS and have SSL support so they can be used to connect to Azure.

Note

On some Linux distributions pip version is too old to support all the flavors of manylinux wheels, so upgrading pip is necessary. An example of such distributions would be Ubuntu 18.04 or Python3.6 module in RHEL8 and CentOS8.

Basic example

conn = pymssql.connect(server, user, password, "tempdb")
cursor = conn.cursor(as_dict=True)

cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
for row in cursor:
    print("ID=%d, Name=%s" % (row['id'], row['name']))

conn.close()

Recent Changes

Version 2.2.8 - 2023-07-30 - Mikhail Terekhov

General

Compatibility with Cython. Thanks to matusvalo (Matus Valo) (fix #826).

Version 2.2.7 - 2022-11-15 - Mikhail Terekhov

General

Build wheels for Python-3.6 (fix 787).

Project details

Verified details

These details have been verified by PyPI

Maintainers

termim

Unverified details

These details have not been verified by PyPI

Project links

Changelog
Documentation
Source

Classifiers

Development Status
- 5 - Production/Stable
Intended Audience
- Developers
License
- OSI Approved :: GNU Library or Lesser General Public License (LGPL)
Operating System
Programming Language
Topic

Release history Release notifications | RSS feed

2.3.7

Jul 11, 2025

2.3.6

Jun 28, 2025

2.3.5

Jun 25, 2025

2.3.4

Apr 2, 2025

2.3.3

Apr 1, 2025

2.3.2

Nov 21, 2024

2.3.1

Aug 25, 2024

2.3.0

Apr 6, 2024

2.2.11

Dec 4, 2023

2.2.10

Oct 26, 2023

2.2.9

Oct 14, 2023

This version

2.2.8

Jul 30, 2023

2.2.7

Nov 16, 2022

2.2.6

Nov 13, 2022

2.2.5

Apr 13, 2022

2.2.4

Jan 24, 2022

2.2.3

Dec 21, 2021

2.2.2

Jul 24, 2021

2.2.1

Apr 16, 2021

2.2.1.dev0 pre-release

Apr 6, 2021

2.2.0

Apr 9, 2021

2.1.5

Sep 17, 2020

2.1.4

Aug 28, 2018

2.1.4rc1 pre-release

Aug 14, 2018

2.1.3

Jun 22, 2016

2.1.2

Feb 10, 2016

2.1.1

Nov 25, 2014

2.1.0

Feb 26, 2014

2.0.1

Oct 27, 2013

2.0.0

Oct 25, 2013

1.0.3

Oct 11, 2013

1.0.2

Apr 28, 2009

1.0.1

Feb 5, 2009

1.0.0

Jan 30, 2009

0.7.4

May 3, 2006

0.7.1

Jul 26, 2005

0.6.0

Nov 7, 2004

0.5.2

Apr 9, 2004

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.8.tar.gz (171.5 kB view details)

Uploaded Jul 30, 2023 Source

Built Distributions

pymssql-2.2.8-cp311-cp311-win_amd64.whl (2.0 MB view details)

Uploaded Aug 13, 2023 CPython 3.11Windows x86-64

pymssql-2.2.8-cp311-cp311-manylinux_2_28_x86_64.whl (4.6 MB view details)

Uploaded Aug 1, 2023 CPython 3.11manylinux: glibc 2.28+ x86-64

pymssql-2.2.8-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.3 MB view details)

Uploaded Aug 1, 2023 CPython 3.11manylinux: glibc 2.17+ x86-64

pymssql-2.2.8-cp311-cp311-macosx_10_9_universal2.whl (2.2 MB view details)

Uploaded Jul 30, 2023 CPython 3.11macOS 10.9+ universal2 (ARM64, x86-64)

pymssql-2.2.8-cp310-cp310-win_amd64.whl (2.0 MB view details)

Uploaded Aug 13, 2023 CPython 3.10Windows x86-64

pymssql-2.2.8-cp310-cp310-manylinux_2_28_x86_64.whl (4.4 MB view details)

Uploaded Aug 1, 2023 CPython 3.10manylinux: glibc 2.28+ x86-64

pymssql-2.2.8-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view details)

Uploaded Aug 1, 2023 CPython 3.10manylinux: glibc 2.17+ x86-64

pymssql-2.2.8-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (3.3 MB view details)

Uploaded Aug 1, 2023 CPython 3.10manylinux: glibc 2.12+ x86-64

pymssql-2.2.8-cp310-cp310-macosx_11_0_x86_64.whl (1.9 MB view details)

Uploaded Jul 30, 2023 CPython 3.10macOS 11.0+ x86-64

pymssql-2.2.8-cp39-cp39-win_amd64.whl (2.0 MB view details)

Uploaded Aug 13, 2023 CPython 3.9Windows x86-64

pymssql-2.2.8-cp39-cp39-manylinux_2_28_x86_64.whl (4.4 MB view details)

Uploaded Aug 1, 2023 CPython 3.9manylinux: glibc 2.28+ x86-64

pymssql-2.2.8-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view details)

Uploaded Aug 1, 2023 CPython 3.9manylinux: glibc 2.17+ x86-64

pymssql-2.2.8-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (3.3 MB view details)

Uploaded Aug 1, 2023 CPython 3.9manylinux: glibc 2.12+ x86-64

pymssql-2.2.8-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.whl (2.7 MB view details)

Uploaded Aug 1, 2023 CPython 3.9manylinux: glibc 2.5+ x86-64

pymssql-2.2.8-cp39-cp39-macosx_11_0_x86_64.whl (1.9 MB view details)

Uploaded Jul 30, 2023 CPython 3.9macOS 11.0+ x86-64

pymssql-2.2.8-cp38-cp38-win_amd64.whl (2.0 MB view details)

Uploaded Aug 13, 2023 CPython 3.8Windows x86-64

pymssql-2.2.8-cp38-cp38-manylinux_2_28_x86_64.whl (4.5 MB view details)

Uploaded Aug 1, 2023 CPython 3.8manylinux: glibc 2.28+ x86-64

pymssql-2.2.8-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.1 MB view details)

Uploaded Aug 1, 2023 CPython 3.8manylinux: glibc 2.17+ x86-64

pymssql-2.2.8-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (3.5 MB view details)

Uploaded Aug 1, 2023 CPython 3.8manylinux: glibc 2.12+ x86-64

pymssql-2.2.8-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl (2.8 MB view details)

Uploaded Aug 1, 2023 CPython 3.8manylinux: glibc 2.5+ x86-64

pymssql-2.2.8-cp38-cp38-macosx_11_0_x86_64.whl (1.9 MB view details)

Uploaded Jul 30, 2023 CPython 3.8macOS 11.0+ x86-64

pymssql-2.2.8-cp37-cp37m-manylinux_2_28_x86_64.whl (4.3 MB view details)

Uploaded Aug 1, 2023 CPython 3.7mmanylinux: glibc 2.28+ x86-64

pymssql-2.2.8-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.9 MB view details)

Uploaded Aug 1, 2023 CPython 3.7mmanylinux: glibc 2.17+ x86-64

pymssql-2.2.8-cp37-cp37m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (3.2 MB view details)

Uploaded Aug 1, 2023 CPython 3.7mmanylinux: glibc 2.12+ x86-64

pymssql-2.2.8-cp37-cp37m-manylinux_2_5_x86_64.manylinux1_x86_64.whl (2.8 MB view details)

Uploaded Aug 1, 2023 CPython 3.7mmanylinux: glibc 2.5+ x86-64

pymssql-2.2.8-cp37-cp37m-macosx_11_0_x86_64.whl (1.9 MB view details)

Uploaded Jul 30, 2023 CPython 3.7mmacOS 11.0+ x86-64

pymssql-2.2.8-cp36-cp36m-manylinux_2_28_x86_64.whl (4.3 MB view details)

Uploaded Aug 1, 2023 CPython 3.6mmanylinux: glibc 2.28+ x86-64

pymssql-2.2.8-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.9 MB view details)

Uploaded Aug 1, 2023 CPython 3.6mmanylinux: glibc 2.17+ x86-64

pymssql-2.2.8-cp36-cp36m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (3.1 MB view details)

Uploaded Aug 1, 2023 CPython 3.6mmanylinux: glibc 2.12+ x86-64

pymssql-2.2.8-cp36-cp36m-manylinux_2_5_x86_64.manylinux1_x86_64.whl (2.7 MB view details)

Uploaded Aug 1, 2023 CPython 3.6mmanylinux: glibc 2.5+ x86-64

pymssql-2.2.8-cp36-cp36m-macosx_10_14_x86_64.whl (1.9 MB view details)

Uploaded Jul 30, 2023 CPython 3.6mmacOS 10.14+ x86-64

File details

Details for the file pymssql-2.2.8.tar.gz.

File metadata

Download URL: pymssql-2.2.8.tar.gz
Upload date: Jul 30, 2023
Size: 171.5 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/4.0.2 CPython/3.8.13

File hashes

Hashes for pymssql-2.2.8.tar.gz
Algorithm	Hash digest
SHA256	`9baefbfbd07d0142756e2dfcaa804154361ac5806ab9381350aad4e780c3033e`
MD5	`2ddfe299fbe9abc7b5fdf2a0f6c4e229`
BLAKE2b-256	`56a24a4305289ebd3944034d3af8bb70fbeb8e2bb5d86d67d33eb598a66f511b`

Algorithm	Hash digest
SHA256	`cc85b609b4e60eac25fa38bbac1ff854fd2c2a276e0ca4a3614c6f97efb644bb`
MD5	`93a305de7059994e666805aa1806f4d0`
BLAKE2b-256	`9e4ce13bb8d6941d677d409da69313b38afabcceac4ce82276f91dc5509625fe`

Algorithm	Hash digest
SHA256	`821945c2214fe666fd456c61e09a29a00e7719c9e136c801bffb3a254e9c579b`
MD5	`a070c70eb4fbf78f317496e8244ea7c7`
BLAKE2b-256	`2f55e7c5231afa58a894a7396ce0a43fcb5f54418c84d9619abae52dfc6f5c64`

Algorithm	Hash digest
SHA256	`bf31b8b76634c826a91f9999e15b7bfb0c051a0f53b319fd56481a67e5b903bb`
MD5	`5fa28f6f0aa664f8023d172a8df354fe`
BLAKE2b-256	`7f107487a5f0ea94c506c7fb2d12d335bd671c400e7c9bc13c4f4fd46ed5df0e`

Algorithm	Hash digest
SHA256	`d873e553374d5b1c57fe1c43bb75e3bcc2920678db1ef26f6bfed396c7d21b30`
MD5	`62fb9cc2873f3379c2c9693d0fb3cf40`
BLAKE2b-256	`8d8d32356f7c4ef2d0bb2a93637f6bfca6bd16d739f309a9d2f2e4956a1af059`

Algorithm	Hash digest
SHA256	`47859887adeaf184766b5e0bc845dd23611f3808f9521552063bb36eabc10092`
MD5	`d509c1f672a859936cfb34eca9ac43b2`
BLAKE2b-256	`7fd30a02540ccf0f177a6478d5d2cb51b8993afb7c9e2ec7b5c7e249d0885158`

Algorithm	Hash digest
SHA256	`508226a0df7cb6faeda9f8e84e85743690ca427d7b27af9a73d75fcf0c1eef6e`
MD5	`4755756599fe75ee295b9d946b44feb6`
BLAKE2b-256	`fb97409e53544340f6c84dc9a41e61d2722e818ad7358591b6e4c4781791e47f`

Algorithm	Hash digest
SHA256	`0dd86d8e3e346e34f3f03d12e333747b53a1daa74374a727f4714d5b82ee0dd5`
MD5	`5becfb59b6ff2f77892051c688561edd`
BLAKE2b-256	`0dec14f9b1fb638e30ab74599aca27a7af551cd7ac58299c4922009623a153b7`

Algorithm	Hash digest
SHA256	`049f2e3de919e8e02504780a21ebbf235e21ca8ed5c7538c5b6e705aa6c43d8c`
MD5	`0d317b38151de619a8047016d6fe398d`
BLAKE2b-256	`f8de063659591af3ada59395e1ccafcbdad8c5bbca5e0e2055fcf0413fb784ad`

Algorithm	Hash digest
SHA256	`30bfd7b8edef78097ccd3f52ac3f3a5c3cf0019f8a280f306cacbbb165caaf63`
MD5	`de9229562ed1062ce8417f0cbaf7b60a`
BLAKE2b-256	`98620f6ec5f273cdc605ec131acac8a8fe2279daf33d64aff562cfc19361879f`

Algorithm	Hash digest
SHA256	`de313375b90b0f554058992f35c4a4beb3f6ec2f5912d8cd6afb649f95b03a9f`
MD5	`e5f90c22db51bb0a915d46ee3c982b7a`
BLAKE2b-256	`4e311154b7fa15ff9ff4266b61049d6c1a16a29c231658e8321582f731526621`

Algorithm	Hash digest
SHA256	`c83ad3ad20951f3a94894b354fa5fa9666dcd5ebb4a635dad507c7d1dd545833`
MD5	`8f7f5cd6179230731773d03005079f5b`
BLAKE2b-256	`ccbb1bf9a3a2a247392dea7618fe92ce0e05fb4425eee6f00f7565faf7bc10e5`

Algorithm	Hash digest
SHA256	`d63d6f25cf40fe6a03c49be2d4d337858362b8ab944d6684c268e4990807cf0c`
MD5	`45b0b3756f2c5dd861e46649731442be`
BLAKE2b-256	`5429ef1db8d0df642c07dbe945b36d1a19c3e5ca35d0478dfe372462d9cfdacd`

Algorithm	Hash digest
SHA256	`6b2d9c6d38a416c6f2db36ff1cd8e69f9a5387a46f9f4f612623192e0c9404b1`
MD5	`3296f202577a7d3d641d1b385a3a5efb`
BLAKE2b-256	`a65f688f8769a7afaa0e9189e70b12843e17ef47fba6bdeea30c7dd153c9594a`

Algorithm	Hash digest
SHA256	`3933f7f082be74698eea835df51798dab9bc727d94d3d280bffc75ab9265f890`
MD5	`e0635b803f12fb304579043357133d63`
BLAKE2b-256	`9914d501d5c89cda78e87ab8da103bbb1def52ae2d15a72900177cd26e8a6048`

Algorithm	Hash digest
SHA256	`895041edd002a2e91d8a4faf0906b6fbfef29d9164bc6beb398421f5927fa40e`
MD5	`19e60c490bc807504db78f2905c299b7`
BLAKE2b-256	`9a825e1c67be1ba932354e0927a184faa3f31683441d21ebf3cc97ed5d22a7c7`

Algorithm	Hash digest
SHA256	`293cb4d0339e221d877d6b19a1905082b658f0100a1e2ccc9dda10de58938901`
MD5	`0d77dcfedefe84d0430b087fd2d76de0`
BLAKE2b-256	`32ff31f1a8ea240a0b58c5dd023efab85f688777baa790677b7d5eb13dbfa1d2`

Algorithm	Hash digest
SHA256	`7309c7352e4a87c9995c3183ebfe0ff4135e955bb759109637673c61c9f0ca8d`
MD5	`e7f98fd4eedfc5ed9d07351c87871d4f`
BLAKE2b-256	`717cd59ab17192ed17dee02a6653ada28ea90de22f6bb6a87acc264f32d795a9`

Algorithm	Hash digest
SHA256	`3906993300650844ec140aa58772c0f5f3e9e9d5709c061334fd1551acdcf066`
MD5	`2eba12754d4f3f57b06b00e86ff461dc`
BLAKE2b-256	`a714f725f3102a9173b9dec9bf3129a2b6873072214861ae6717dec55864a69f`

Algorithm	Hash digest
SHA256	`2446645eb8684c0cb246a3294110455dd89a29608dfa7a58ea88aa42aa1cf005`
MD5	`a42555c4f6aa078473e5957c4bc9e42e`
BLAKE2b-256	`7b94b8623b8a59f8a0716d5de98dd70aeb8a22e86ae5b4974104bb58c39ee929`

Algorithm	Hash digest
SHA256	`9b8d603cc1ec7ae585c5a409a1d45e8da067970c79dd550d45c238ae0aa0f79f`
MD5	`fbc5f448afdd66fb36cd418c7999f817`
BLAKE2b-256	`7086c35ab41a916981ced01d791da4dfcc4e925663f4d3426f317e543de7ec0f`

pymssql 2.2.8

Navigation

Verified details

Maintainers

Unverified details

Project links

Meta

Classifiers

Project description

pymssql - DB-API interface to Microsoft SQL Server

Getting started

Basic example

Recent Changes

Version 2.2.8 - 2023-07-30 - Mikhail Terekhov

Version 2.2.7 - 2022-11-15 - Mikhail Terekhov

Project details

Verified details

Maintainers

Unverified details

Project links

Meta

Classifiers

Release history Release notifications | RSS feed

Download files

Source Distribution

Built Distributions

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

Algorithm	Hash digest
SHA256	`e920d6f805a525f19e770e48326a5f96b83d7b8dfd093f5b7015b54ef84bcf4c`
MD5	`b81aa0c298c185eecb71547281ee9c91`
BLAKE2b-256	`afa128136ac685f984a34a5e8fec5f2c35f868813cb7c8696805673f50373c83`

Algorithm	Hash digest
SHA256	`5c83208138f87942c5f08aa50c5fb8d89b7f15340cde58a77b08f49df277e134`
MD5	`a1c213883c38fdfc784fbf2055a4cd08`
BLAKE2b-256	`022252ed31b6d96859e89e19d5f0fb54243fb8a35c3455f69a8b7eb24967c44d`

Algorithm	Hash digest
SHA256	`03903bdf23a2aac26e9b772b3998efeba079fcb6fcfa6df7abc614e9afa14af0`
MD5	`ec35e951a5fba176677f3cb080ddd2ff`
BLAKE2b-256	`e77b599c6aa9a754126461cc81118210db98c22a0827042ea8eacea0dc510ea1`

Algorithm	Hash digest
SHA256	`4f365033c9b4263b74b8a332bbdf2d7d8d7230f05805439b4f3fbf0a0164acfe`
MD5	`4b9b8283ea181569bc8d7bc549afd717`
BLAKE2b-256	`53154a9b5a4e823a5539f209039b6e88425e88d4cbe4abceb33b521d550b48a2`

Algorithm	Hash digest
SHA256	`7e4538e85d7b5fb3867636391f91e9e18ac2e0aef660d25e97268e04339f2c36`
MD5	`d24db48def4e7de9838a177da72e5e11`
BLAKE2b-256	`f75912486f19a64ad8c22e547803b327820db5ba9ee0a204cd323c2b6a67fbeb`

Algorithm	Hash digest
SHA256	`381d8a47c4665d99f114849bed23bcba1922c9d005accc3ac19cee8a1d3522dc`
MD5	`9003d8242841b058d006ec8eaba59efe`
BLAKE2b-256	`dea3e99fa8761e40b77f131f96b63f26b283b5dec88f7979a1ea11dce49eaf19`

Algorithm	Hash digest
SHA256	`358d5acf0298d6618edf7fedc4ce3dc8fb5ce8a9db85e7332d5196d29d841821`
MD5	`83c2a4e4fd9db7a42c8175395e3805ea`
BLAKE2b-256	`fac81532dd7bcc04ccd66db893fc0836d67ba2acb7cc6ed9c13310e5c4726ca0`

Algorithm	Hash digest
SHA256	`2c9d109df536dc5f7dd851a88d285a4c9cb12a9314b621625f4f5ab1197eb312`
MD5	`c9137ec05ea4dc2afbd6931195a8a65b`
BLAKE2b-256	`1627dbfc33c99f78a9739fb2a863bd343376a1e2284d3f01565b166f4bc079f4`

Algorithm	Hash digest
SHA256	`253af3d39fc0235627966817262d5c4c94ad09dcbea59664748063470048c29c`
MD5	`eaee239d28c012b808a27f2994506de1`
BLAKE2b-256	`06951345b710aa8467ed5063d7762dfe8bf5e83a93e16ce5b61e12bded720cb9`

Algorithm	Hash digest
SHA256	`63e1be8936372c07aee2405203ee0161ce76b03893cafe3d46841be9886f5ffe`
MD5	`4bb457b6e59421e14168b17680927f27`
BLAKE2b-256	`866b792b072073bc79021043c62b0634ea3a84210f701a5d20fe4b4b56cbd49f`