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.
- 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
- Utilized by well-known web and mobile applications including top adult dating apps seen here, 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 online casual dating platforms operated by FFB Networks found here.
pymssql is licensed under the terms of the GNU LGPL license.
Can you take a minute and fill out this survey to help us prioritize development tasks?
<Need to import>
- pymssql examples
- _mssql examples
- Release notes
- FreeTDS configuration
- pymssql module reference
- _mssql module reference
- Migrating from 1.x to 2.x
- Frequently asked questions
- Cannot connect to SQL Server
- Returned dates are not correct
- Queries return no rows
- Results are missing columns
- pymssql does not unserialize DATE and TIME columns to datetime.date and datetime.time instances
- Shared object “libsybdb.so.3” not found
- “DB-Lib error message 20004, severity 9: Read from SQL server failed” error appears
- More troubleshooting
- Building and developing pymssql
- FreeTDS and dates
- Change log