id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 5061 New backend for Sql Server using pymssql mamcx Adrian Holovaty "Related to [http://groups.google.com/group/django-developers/browse_thread/thread/c7029442e8a47079 this thread] I code a new backend for Sql Server using Sql Server. This is a alpha version... and I put it here so can get early feedback. Is not production ready. == Hacked on == - Sql Server 2000 SP1[[BR]] - WinXP PRO 64 bits[[BR]] - Python 2.4[[BR]] - Django rev 5783[[BR]] == What's on: == - Merge of several code & tickets around, including the original ado_mssql code as base.[[BR]] - Based on [http://pymssql.sourceforge.net/ pymssql 0.8.0] so in theroy must work across plataforms. This have some bugs and issues so please install it from pymssql site and then apply the patch here. Include detection of boolean types, support of autocommit, splits on GO, and not mask python errors as sql server fault.[[BR]] - Fix problems with dateformat on nonenglish sql instalations.[[BR]] - Tested using included django\tests>runtests.py, with the tutorial, satchmo rev 590 with not fatal errors.[[BR]] - Detection of Sql Server version, so later can apply optimizations based on this information.[[BR]] - Implemented client.py (so python manage.py dbshell work).[[BR]] == What's left == - No LIMIT/OFFSET emulation. I'm learning about the Oracle backend for apply a similar aproach. I think however is a doable task with the refactoring of query class.[[BR]] - No get_deferrable_sql (aka CASCADE delete/update on relations). Sql Server is very sensitive about circular references.[[BR]] - Testing against Sql 2005 and on linux.[[BR]] - Login using integrated security (on windows)[[BR]] - Check what happend with multiples collations[[BR]] == What's uggly == - Barney and their friends[[BR]] - Seriously, check db\models line 242+: How detect properly autoinc fields?[[BR]]" closed Database layer (models, ORM) dev duplicate ms sql server Unreviewed 1 0 0 0 0 0