ppc64le/linux-1.0.0/: pymssql-2.3.2 metadata and description

Simple index Newer version available

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

author Damien Churchill
author_email [email protected]
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.7
  • Programming Language :: Python :: 3.8
  • Programming Language :: Python :: 3.9
  • Programming Language :: Python :: 3.10
  • Programming Language :: Python :: 3.11
  • Programming Language :: Python :: 3.12
  • 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
  • Environment :: MetaData :: IBM Python Ecosystem
description_content_type text/x-rst
dynamic
  • author
  • author-email
  • classifier
  • description
  • description-content-type
  • keywords
  • license
  • license-file
  • maintainer
  • maintainer-email
  • platform
  • project-url
  • summary
keywords mssql,SQL Server,database,DB-API
license LGPL
license_file
  • LICENSE
maintainer Mikhail Terekhov
maintainer_email [email protected]
project_urls
  • Documentation, http://pymssql.readthedocs.io
  • Source, https://github.com/pymssql/pymssql
  • Changelog, https://github.com/pymssql/pymssql/blob/master/ChangeLog.rst
File Tox results History
pymssql-2.3.2-cp310-cp310-linux_ppc64le.whl
Size
6 MB
Type
Python Wheel
Python
3.10
pymssql-2.3.2-cp311-cp311-linux_ppc64le.whl
Size
5 MB
Type
Python Wheel
Python
3.11
pymssql-2.3.2-cp312-cp312-linux_ppc64le.whl
Size
6 MB
Type
Python Wheel
Python
3.12
pymssql-2.3.2-cp313-cp313-linux_ppc64le.whl
Size
6 MB
Type
Python Wheel
Python
3.13
pymssql-2.3.2-cp39-cp39-linux_ppc64le.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.2 - 2024-11-20 - Mikhail Terekhov

General

  • Update FreeTDS to 1.4.23.

  • Build wheels for Python-3.13 on Windows and MacOS.

Internals

  • Fix build wheels for Python-3.13 on Windows.

  • Drop build in actions for Python 3.6, 3.7 and 3.8.

  • Add build in actions for Python-3.13.

  • Workaround setuptools-74.0 changes.

Version 2.3.1 - 2024-08-25 - Mikhail Terekhov

General

  • Fix SP returning NULL (closes #441).

  • Update FreeTDS to 1.4.22 (closes #895).

  • Require Cython>3.0.10.

  • Add python 3.13 Linux wheels (closes #900).

  • Drop manylinux2010 wheels.

  • Drop 3.7 and 3.8 wheels on MacOS.

  • Drop 3.6 wheels on Linux.