Re: microsoft sql server 2005

2008-05-19 Thread Tim Chase

> is it possible to setup python/django and run it on a sql server?

yes, for small values of "run"...you might call it "walking" or 
"crawling" (or maybe "limping") rather than "running".

There has been various bits of code that allow for connecting, 
but SQL-Server is a bit broken in a number of ways that hobble 
Django's functionality.  One of the big ones I noticed was 
data-set slicing (SQL-Server doesn't have a LIMIT/OFFSET syntax 
other than TOP N last I checked, and requires a lot of 
hoop-jumping to get working) which is used by pagination.

Additionally, depending on which interface you use to access the 
server (mxODBC, pymssql, ado_mssql, etc), I've encountered 
occasional driver-related problems particularly with parameter 
escaping.  I usually only hit this in complex queries, but having 
experienced what quality *can* be like with the other drivers, 
these failings left a sour taste in my mouth for working with 
SQL-Server.  This may have just been a problem with the mxODBC 
driver that I have on hand, but YMMV.  There was a ado_mssql 
backend in earlier revisions of trunk but it was removed in 
revision #7364 for lack of maint.

-tim





--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---



Re: microsoft sql server 2005

2008-05-19 Thread Adam V.

It's possible to use Django (trunk, best against 7540 or better to get
the most recent security fixes) against SS2005 with the caveat that
there is no core support for doing this.

I'm maintaining an external database backend here: 
http://code.google.com/p/django-mssql/

That backend works well enough for the work I'm doing, though our site
is mostly read-only against a "legacy" database, so not every corner
of Django's ORM has been tested it.

I'd certainly welcome bug reports (and patches.)

(For what it's worth, we're deploying on Windows XP (dev machines) and
Server 2003, Apache 2.2.6, and mod_python, and I'm working on some
"continuous integration" pieces with CruiseControl.NET. If there was
any interest I could write up some of our set-up instructions.)

-Adam Vandenberg

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---