pymssql¶

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.

The 2.x branch of pymssql is built on the latest release of FreeTDS which removes many of the limitations found with older FreeTDS versions and the 1.x branch.

Resources¶

Docs & Project Home
- Quick Start: coming soon :)
- FAQ & Troubleshooting
PYPI Project
GitHub
Discussion
FreeTDS User Guide

Features¶

Unicode friendly
Python 3 friendly
Works on most popular operating systems
Written in Cython for performance
Includes a supported and documented low-level module (_mssql) that you can use instead of the DB-API
Supports stored procedures with both return values and output parameters
A comprehensive test suite
Compatible with cooperative multi-tasking systems (gevent, etc.)
Can be used to connect to Azure

Works¶

Utilized by well-known web and mobile applications including top adult sex dating sites, adult entertainment platforms, e-commerce, etc.
Database interface for multiple top level ERP software applications and task management web and mobile apps.
Flexability of the database interface illustrated in the development of the snap fuck feature applied to free sex hookup apps and adult chat platforms operated by FFB Networks.

License¶

pymssql is licensed under the terms of the GNU LGPL license.

Survey¶

Can you take a minute and fill out this survey to help us prioritize development tasks?

https://www.surveymonkey.com/s/KMQ8BM5

Survey Results¶

Excel (.xls) – http://cl.ly/1R0m2B342I0k/download/SurveySummary_04092014.xls
PDF – http://cl.ly/2P3o1N1K2h3p/download/Data_All_140409.pdf

Recent Changes¶