loongson/pypi/: pymssql-2.3.4 metadata and description

Simple index Mirror page

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

author_email Damien Churchill <damoxc@gmail.com>
classifiers
  • Development Status :: 5 - Production/Stable
  • Intended Audience :: Developers
  • License :: OSI Approved :: GNU Library or Lesser General Public License (LGPL)
  • Programming Language :: Python
  • Programming Language :: Python :: 3.9
  • Programming Language :: Python :: 3.10
  • Programming Language :: Python :: 3.11
  • Programming Language :: Python :: 3.12
  • Programming Language :: Python :: 3.13
  • Programming Language :: Python :: Implementation :: CPython
  • Topic :: Database
  • Topic :: Database :: Database Engines/Servers
  • Topic :: Software Development :: Libraries :: Python Modules
  • Operating System :: Microsoft :: Windows
  • Operating System :: POSIX
  • Operating System :: Unix
description_content_type text/x-rst
keywords mssql,SQL Server,database,DB-API
license LGPL
maintainer_email Mikhail Terekhov <termim@gmail.com>
project_urls
  • homepage, https://github.com/pymssql/pymssql
  • repository, https://github.com/pymssql/pymssql
  • documentation, http://pymssql.readthedocs.io
  • Bug Tracker, https://github.com/pymssql/pymssql/issues
  • Changelog, https://github.com/pymssql/pymssql/blob/master/ChangeLog.rst
requires_python >=3.8
File Tox results History
pymssql-2.3.4-cp310-cp310-manylinux_2_38_loongarch64.whl
Size
5 MB
Type
Python Wheel
Python
3.10
pymssql-2.3.4-cp311-cp311-manylinux_2_38_loongarch64.whl
Size
5 MB
Type
Python Wheel
Python
3.11
pymssql-2.3.4-cp312-cp312-manylinux_2_38_loongarch64.whl
Size
5 MB
Type
Python Wheel
Python
3.12
pymssql-2.3.4-cp313-cp313-manylinux_2_38_loongarch64.whl
Size
5 MB
Type
Python Wheel
Python
3.13
pymssql-2.3.4-cp39-cp39-manylinux_2_38_loongarch64.whl
Size
5 MB
Type
Python Wheel
Python
3.9

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.

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.3.4 - 2025-04-01 - Mikhail Terekhov

General

  • Update packaging to fix metadata, thanks to AbigailColwell.

Version 2.3.3 - 2025-03-31 - Mikhail Terekhov

General

  • Update FreeTDS to 1.4.26.

  • Add py.typed which marks pymssql as suporting typechecks, thanks Niklas Mertsch (closes #925).