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
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.
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
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.8-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cc85b609b4e60eac25fa38bbac1ff854fd2c2a276e0ca4a3614c6f97efb644bb |
|
MD5 | 93a305de7059994e666805aa1806f4d0 |
|
BLAKE2b-256 | 9e4ce13bb8d6941d677d409da69313b38afabcceac4ce82276f91dc5509625fe |
Hashes for pymssql-2.2.8-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 821945c2214fe666fd456c61e09a29a00e7719c9e136c801bffb3a254e9c579b |
|
MD5 | a070c70eb4fbf78f317496e8244ea7c7 |
|
BLAKE2b-256 | 2f55e7c5231afa58a894a7396ce0a43fcb5f54418c84d9619abae52dfc6f5c64 |
Hashes for pymssql-2.2.8-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bf31b8b76634c826a91f9999e15b7bfb0c051a0f53b319fd56481a67e5b903bb |
|
MD5 | 5fa28f6f0aa664f8023d172a8df354fe |
|
BLAKE2b-256 | 7f107487a5f0ea94c506c7fb2d12d335bd671c400e7c9bc13c4f4fd46ed5df0e |
Hashes for pymssql-2.2.8-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d873e553374d5b1c57fe1c43bb75e3bcc2920678db1ef26f6bfed396c7d21b30 |
|
MD5 | 62fb9cc2873f3379c2c9693d0fb3cf40 |
|
BLAKE2b-256 | 8d8d32356f7c4ef2d0bb2a93637f6bfca6bd16d739f309a9d2f2e4956a1af059 |
Hashes for pymssql-2.2.8-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 47859887adeaf184766b5e0bc845dd23611f3808f9521552063bb36eabc10092 |
|
MD5 | d509c1f672a859936cfb34eca9ac43b2 |
|
BLAKE2b-256 | 7fd30a02540ccf0f177a6478d5d2cb51b8993afb7c9e2ec7b5c7e249d0885158 |
Hashes for pymssql-2.2.8-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 508226a0df7cb6faeda9f8e84e85743690ca427d7b27af9a73d75fcf0c1eef6e |
|
MD5 | 4755756599fe75ee295b9d946b44feb6 |
|
BLAKE2b-256 | fb97409e53544340f6c84dc9a41e61d2722e818ad7358591b6e4c4781791e47f |
Hashes for pymssql-2.2.8-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0dd86d8e3e346e34f3f03d12e333747b53a1daa74374a727f4714d5b82ee0dd5 |
|
MD5 | 5becfb59b6ff2f77892051c688561edd |
|
BLAKE2b-256 | 0dec14f9b1fb638e30ab74599aca27a7af551cd7ac58299c4922009623a153b7 |
Hashes for pymssql-2.2.8-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 049f2e3de919e8e02504780a21ebbf235e21ca8ed5c7538c5b6e705aa6c43d8c |
|
MD5 | 0d317b38151de619a8047016d6fe398d |
|
BLAKE2b-256 | f8de063659591af3ada59395e1ccafcbdad8c5bbca5e0e2055fcf0413fb784ad |
Hashes for pymssql-2.2.8-cp310-cp310-macosx_11_0_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 30bfd7b8edef78097ccd3f52ac3f3a5c3cf0019f8a280f306cacbbb165caaf63 |
|
MD5 | de9229562ed1062ce8417f0cbaf7b60a |
|
BLAKE2b-256 | 98620f6ec5f273cdc605ec131acac8a8fe2279daf33d64aff562cfc19361879f |
Hashes for pymssql-2.2.8-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | de313375b90b0f554058992f35c4a4beb3f6ec2f5912d8cd6afb649f95b03a9f |
|
MD5 | e5f90c22db51bb0a915d46ee3c982b7a |
|
BLAKE2b-256 | 4e311154b7fa15ff9ff4266b61049d6c1a16a29c231658e8321582f731526621 |
Hashes for pymssql-2.2.8-cp39-cp39-manylinux_2_28_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c83ad3ad20951f3a94894b354fa5fa9666dcd5ebb4a635dad507c7d1dd545833 |
|
MD5 | 8f7f5cd6179230731773d03005079f5b |
|
BLAKE2b-256 | ccbb1bf9a3a2a247392dea7618fe92ce0e05fb4425eee6f00f7565faf7bc10e5 |
Hashes for pymssql-2.2.8-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d63d6f25cf40fe6a03c49be2d4d337858362b8ab944d6684c268e4990807cf0c |
|
MD5 | 45b0b3756f2c5dd861e46649731442be |
|
BLAKE2b-256 | 5429ef1db8d0df642c07dbe945b36d1a19c3e5ca35d0478dfe372462d9cfdacd |
Hashes for pymssql-2.2.8-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6b2d9c6d38a416c6f2db36ff1cd8e69f9a5387a46f9f4f612623192e0c9404b1 |
|
MD5 | 3296f202577a7d3d641d1b385a3a5efb |
|
BLAKE2b-256 | a65f688f8769a7afaa0e9189e70b12843e17ef47fba6bdeea30c7dd153c9594a |
Hashes for pymssql-2.2.8-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3933f7f082be74698eea835df51798dab9bc727d94d3d280bffc75ab9265f890 |
|
MD5 | e0635b803f12fb304579043357133d63 |
|
BLAKE2b-256 | 9914d501d5c89cda78e87ab8da103bbb1def52ae2d15a72900177cd26e8a6048 |
Hashes for pymssql-2.2.8-cp39-cp39-macosx_11_0_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 895041edd002a2e91d8a4faf0906b6fbfef29d9164bc6beb398421f5927fa40e |
|
MD5 | 19e60c490bc807504db78f2905c299b7 |
|
BLAKE2b-256 | 9a825e1c67be1ba932354e0927a184faa3f31683441d21ebf3cc97ed5d22a7c7 |
Hashes for pymssql-2.2.8-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 293cb4d0339e221d877d6b19a1905082b658f0100a1e2ccc9dda10de58938901 |
|
MD5 | 0d77dcfedefe84d0430b087fd2d76de0 |
|
BLAKE2b-256 | 32ff31f1a8ea240a0b58c5dd023efab85f688777baa790677b7d5eb13dbfa1d2 |
Hashes for pymssql-2.2.8-cp38-cp38-manylinux_2_28_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7309c7352e4a87c9995c3183ebfe0ff4135e955bb759109637673c61c9f0ca8d |
|
MD5 | e7f98fd4eedfc5ed9d07351c87871d4f |
|
BLAKE2b-256 | 717cd59ab17192ed17dee02a6653ada28ea90de22f6bb6a87acc264f32d795a9 |
Hashes for pymssql-2.2.8-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3906993300650844ec140aa58772c0f5f3e9e9d5709c061334fd1551acdcf066 |
|
MD5 | 2eba12754d4f3f57b06b00e86ff461dc |
|
BLAKE2b-256 | a714f725f3102a9173b9dec9bf3129a2b6873072214861ae6717dec55864a69f |
Hashes for pymssql-2.2.8-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2446645eb8684c0cb246a3294110455dd89a29608dfa7a58ea88aa42aa1cf005 |
|
MD5 | a42555c4f6aa078473e5957c4bc9e42e |
|
BLAKE2b-256 | 7b94b8623b8a59f8a0716d5de98dd70aeb8a22e86ae5b4974104bb58c39ee929 |
Hashes for pymssql-2.2.8-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9b8d603cc1ec7ae585c5a409a1d45e8da067970c79dd550d45c238ae0aa0f79f |
|
MD5 | fbc5f448afdd66fb36cd418c7999f817 |
|
BLAKE2b-256 | 7086c35ab41a916981ced01d791da4dfcc4e925663f4d3426f317e543de7ec0f |
Hashes for pymssql-2.2.8-cp38-cp38-macosx_11_0_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e920d6f805a525f19e770e48326a5f96b83d7b8dfd093f5b7015b54ef84bcf4c |
|
MD5 | b81aa0c298c185eecb71547281ee9c91 |
|
BLAKE2b-256 | afa128136ac685f984a34a5e8fec5f2c35f868813cb7c8696805673f50373c83 |
Hashes for pymssql-2.2.8-cp37-cp37m-manylinux_2_28_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5c83208138f87942c5f08aa50c5fb8d89b7f15340cde58a77b08f49df277e134 |
|
MD5 | a1c213883c38fdfc784fbf2055a4cd08 |
|
BLAKE2b-256 | 022252ed31b6d96859e89e19d5f0fb54243fb8a35c3455f69a8b7eb24967c44d |
Hashes for pymssql-2.2.8-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 03903bdf23a2aac26e9b772b3998efeba079fcb6fcfa6df7abc614e9afa14af0 |
|
MD5 | ec35e951a5fba176677f3cb080ddd2ff |
|
BLAKE2b-256 | e77b599c6aa9a754126461cc81118210db98c22a0827042ea8eacea0dc510ea1 |
Hashes for pymssql-2.2.8-cp37-cp37m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4f365033c9b4263b74b8a332bbdf2d7d8d7230f05805439b4f3fbf0a0164acfe |
|
MD5 | 4b9b8283ea181569bc8d7bc549afd717 |
|
BLAKE2b-256 | 53154a9b5a4e823a5539f209039b6e88425e88d4cbe4abceb33b521d550b48a2 |
Hashes for pymssql-2.2.8-cp37-cp37m-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7e4538e85d7b5fb3867636391f91e9e18ac2e0aef660d25e97268e04339f2c36 |
|
MD5 | d24db48def4e7de9838a177da72e5e11 |
|
BLAKE2b-256 | f75912486f19a64ad8c22e547803b327820db5ba9ee0a204cd323c2b6a67fbeb |
Hashes for pymssql-2.2.8-cp37-cp37m-macosx_11_0_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 381d8a47c4665d99f114849bed23bcba1922c9d005accc3ac19cee8a1d3522dc |
|
MD5 | 9003d8242841b058d006ec8eaba59efe |
|
BLAKE2b-256 | dea3e99fa8761e40b77f131f96b63f26b283b5dec88f7979a1ea11dce49eaf19 |
Hashes for pymssql-2.2.8-cp36-cp36m-manylinux_2_28_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 358d5acf0298d6618edf7fedc4ce3dc8fb5ce8a9db85e7332d5196d29d841821 |
|
MD5 | 83c2a4e4fd9db7a42c8175395e3805ea |
|
BLAKE2b-256 | fac81532dd7bcc04ccd66db893fc0836d67ba2acb7cc6ed9c13310e5c4726ca0 |
Hashes for pymssql-2.2.8-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2c9d109df536dc5f7dd851a88d285a4c9cb12a9314b621625f4f5ab1197eb312 |
|
MD5 | c9137ec05ea4dc2afbd6931195a8a65b |
|
BLAKE2b-256 | 1627dbfc33c99f78a9739fb2a863bd343376a1e2284d3f01565b166f4bc079f4 |
Hashes for pymssql-2.2.8-cp36-cp36m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 253af3d39fc0235627966817262d5c4c94ad09dcbea59664748063470048c29c |
|
MD5 | eaee239d28c012b808a27f2994506de1 |
|
BLAKE2b-256 | 06951345b710aa8467ed5063d7762dfe8bf5e83a93e16ce5b61e12bded720cb9 |
Hashes for pymssql-2.2.8-cp36-cp36m-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 63e1be8936372c07aee2405203ee0161ce76b03893cafe3d46841be9886f5ffe |
|
MD5 | 4bb457b6e59421e14168b17680927f27 |
|
BLAKE2b-256 | 866b792b072073bc79021043c62b0634ea3a84210f701a5d20fe4b4b56cbd49f |
Hashes for pymssql-2.2.8-cp36-cp36m-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ebe7f64d5278d807f14bea08951e02512bfbc6219fd4d4f15bb45ded885cf3d4 |
|
MD5 | 865c9e3b6bda782b0f64953f4e6bcb88 |
|
BLAKE2b-256 | 199e5ce1a589ecbd15e3b9db3c931ebc5e48c971ba9b3367721be784f54e0faa |