Sidebar Network

django-pyodbc MS SQL Server backend using pyodbc for Django.

The Basics

This seems to be the most mature SQL Server driver for Python and is still maintained, which is a big plus compared to other SQL Server drivers like adodbapi and pymssql. Pyodbc is also used by SQLAlchemy for SQL Server connections.

  • Native Unicode support. Every string that goes in is stored as Unicode, and every string that goes out of the database is returned as Unicode. No conversion to/from intermediate encodings takes place, so things like max_length in CharFiled works just like expected.
  • Limit/offset supported in SQL Server 2005 and SQL Server 2000. Yay!
  • Both Windows Authentication (Integrated Security) and SQL Server Authentication supported. Passes most of the model test cases. The tests that don’t work out of the box are: o empty: Corner-case. As far as I know SQL Server 2005 does not support that. There seems to be little use of it at all. o lookup: Regular expressions are not supported out of the box. Only simple wildcard matching with %, and [] character classes. o serializers: Forward references cause foreign key constraint violation.
  • Tested with SQL Server 2005 Express SP2 and SQL Server 2000 SP4, Python 2.5 and Windows XP.
Project Home – http://code.google.com/p/django-pyodbc/
Grab the Repository – svn checkout http://django-pyodbc.googlecode.com/svn/trunk/
 

Recent Commits

  • 26 was committed 5 days, 7 hours ago.
    Update introspection.
  • 25 was committed 5 days, 7 hours ago.
    Fixed [Issue 8]:hard-coded import from django.db.backends.mssql , thanks Ulf Kronman.
  • 24 was committed 5 days, 7 hours ago.
    Update to django 1.0 beta 1. Fixed after Django ticket #5461 — Refactored the database backend code to use classes for the creation and introspection modules.
  • 23 was committed 1 week, 6 days ago.
    move sqlserver_version from connection.ops back to connection, fixed Issuse 5: format_result break FreeTDS unicode output, thanks Ulf Kronman.
  • 22 was committed 3 weeks, 1 day ago.
    Remove patch django section in README.TXT
  • 21 was committed 3 weeks, 1 day ago.
    Change for Django #7560 fixed. No need patch django trunk any more.
  • 20 was committed 1 month ago.
    fixed some errors, passed almost the modeltests and regressiontests
  • 19 was committed 1 month ago.
    Remove old r7250 patch.
  • 18 was committed 1 month ago.
    Remove old files.
  • 17 was committed 1 month ago.
    fixed sql2000 order by bug. Thank Ramiro Morales and Andrew Magee.