This release is a pre-release and may not be stable for production use.
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 pymssqlMost 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.7 - 2022-11-15 - Mikhail Terekhov
General
Build wheels for Python-3.6 (fix 787).
Version 2.2.6 - 2022-11-12 - Mikhail Terekhov
General
Build wheels for Python-3.11.
Use FreeTDS-1.3.13 for official wheels on PyPi.
Fix build on Alpine Linux (fix #762).
Fill in result description in cursor.callproc (fix #772).
Add explicit link to krb5 (fix #776), thanks to James Coder.
Some small doc fixes, thanks to guillaumep and Logan Elandt.
1 maintainer
Metadata
1 maintainer
Release files for pymssql-jp100procent 0.1.dev1192
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| pymssql-jp100procent-0.1.dev1192.tar.gz | 173.2 kB | Details |
Release files / pymssql-jp100procent-0.1.dev1192.tar.gz
| Download URL | pymssql-jp100procent-0.1.dev1192.tar.gz |
|---|---|
| Size | 173.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
75e38640d07354a3532964656675fd5d83f0e8715132568a3a0cf320996cb715
|
|
BLAKE2b-256 checksum How to use checksums |
911a6e843af895b011ca0b2f0349e17b7381d718c02f82e484c1e89f7a97266a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.11
|
