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.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.
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
Hashes for pymssql-jp100procent-0.1.dev1192.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 75e38640d07354a3532964656675fd5d83f0e8715132568a3a0cf320996cb715 |
|
MD5 | 4a0f06536d59c26e5db9cf558f61508a |
|
BLAKE2b-256 | 911a6e843af895b011ca0b2f0349e17b7381d718c02f82e484c1e89f7a97266a |