I use it for several applicartions. Not sure that there is any difference
with the various versions of sql server, except for minor syntax issues.
What did you want to know?
The performance is very good.
I have one application in which I use the admin interface which uses the
ORM and I have a
Hi all,
Can anyone share his experience about developing application with django
that uses Microsoft SQL server 2005 or later ?
And how is it in production environment.
Thanks
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this g
Good morning all,
Can someone share with me its experience with Django application running on
MS SQL DB? I have a heavy application that i want to migrate to django.
Please can you share your experience with me in term of stability and
feasibility? How does django teamup with MS SQL.
Regards.
Cheng Zhang wrote:
Hi Cheng,
> Actually my previous statement isn't correct, I just realized that
> pymssql also claimed to work on Windows, except it will use M$'s
> native libraries instead of FreeTDS.
You worked this out quicker than I ever could have. Thanks.
On Jan 21, 2006, at 7:12 AM, Jeremy Dunck wrote:
On 1/20/06, Cheng Zhang <[EMAIL PROTECTED]> wrote:
Adapter class over adodbapi where supported, falling back to
pymssql?
I think they (ado_mssql and pymssql) are meant for different OS
platforms, in that ado_mssql is for Django running on W
Ok, the patch is away [http://code.djangoproject.com/ticket/1258]. :-)
- Cheng Zhang
On 1/20/06, Cheng Zhang <[EMAIL PROTECTED]> wrote:
> > Adapter class over adodbapi where supported, falling back to pymssql?
>
> I think they (ado_mssql and pymssql) are meant for different OS
> platforms, in that ado_mssql is for Django running on Windows to
> connect to SQL Server since it only
On Jan 13, 2006, at 12:40 AM, Jeremy Dunck wrote:
On 1/12/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
The pymssql driver only supports DB-LIB, which is way outdated and
you
wont have access to functionality added to MSSQL after version 6.5.
This is not the best option IMHO.
Adapter class o
Actually that's incorrect. Pymssql is only a thin wrapper around
FreeTDS library (http://www.freetds.org/).
AFAIK, FreeTDS works with SQL-Server 2000 pretty well.
- Cheng
On Jan 13, 2006, at 12:15 AM, Rich Bakos wrote:
Jeroen Ruigrok van der Werven wrote:
Hi Jeroen,
Can a bunch of us ge
On 1/20/06, Cheng Zhang <[EMAIL PROTECTED]> wrote:
> Just a quick report on the status on pymssql backend, after being
> busy for nearly 2 weeks, today I finally found a big trunk of time
> (~10 hrs) to hack it, and the result is that there are only 4 errors
> (shown below) out of all Django docte
=
Code: 'a4.pub_date'
Line: 86
Expected: 'datetime.date(2005, 8, 22)\n'
Got: 'datetime.datetime(2005, 8, 22, 0, 0)\n'
4 errors:
-
On Jan 11, 2006, at 4:28 AM, Cheng Zhang wrote:
On Jan 10, 2006, at 10:21 PM, Adrian Holovaty wrote:
On 1/9/06,
Jeremy Dunck wrote:
> On 1/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > think adodbapi DOES use parameterization. It's just slightly
> > non-standard. (thus, the %s -> ? stuff above)
>
> I was surprised by this, by the Python DB API allows for parameters in
> the string supplied to the
Hi Rich,
On 1/12/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> The pymssql driver only supports DB-LIB, which is way outdated and you
> wont have access to functionality added to MSSQL after version 6.5.
> This is not the best option IMHO.
Yeah, spoke too soon.
The adodbapi seems the way forward f
On 1/12/06, Jeremy Dunck <[EMAIL PROTECTED]> wrote:
>
> On 1/12/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> > The pymssql driver only supports DB-LIB, which is way outdated and you
> > wont have access to functionality added to MSSQL after version 6.5.
> > This is not the best option IMHO.
>
> Ada
On 1/12/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> The pymssql driver only supports DB-LIB, which is way outdated and you
> wont have access to functionality added to MSSQL after version 6.5.
> This is not the best option IMHO.
Adapter class over adodbapi where supported, falling back to pymssql
Jeroen Ruigrok van der Werven wrote:
Hi Jeroen,
> Can a bunch of us get together to get a/the pymssql driver fully
> operational and Django running as it should?
The pymssql driver only supports DB-LIB, which is way outdated and you
wont have access to functionality added to MSSQL after versio
On 1/10/06, Cheng Zhang <[EMAIL PROTECTED]> wrote:
> As matter of fact, I am trying to make pymssql backend for Django
> work since in my current project we have to inherit a MS-SQL
> database. Changing the database is definitely not an option. If
> Django can be used with MS-SQL, then I can convin
On 1/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> think adodbapi DOES use parameterization. It's just slightly
> non-standard. (thus, the %s -> ? stuff above)
I was surprised by this, by the Python DB API allows for parameters in
the string supplied to the provider, and makes it provider
Actually...SQL Server would cache the execution plan anyway. It's
gotten smart enough to do that now. (When parsing the statement, it
recognizes the "style", and caches the plan like it would for a
parameterized query. They call it auto-parameterization, IIRC.).
Parameters improve the db engine's
On Tue, 10 Jan 2006 14:33:18 -0600 Adrian Holovaty wrote:
> The problem is that the SQL Server database backend (the "adodbapi"
> library) assumes placeholders use "?" for placeholders. So the Django
> layer needs to convert all "%s" placeholders in the query to "?".
>
> It looks like the curren
Jeremy Dunck wrote:
Hi Jeremy,
> Yeah, adodbapi was doing something weird with the executeHelper, so we did
> this:
Yeah I worked that out but haven't gotten too far. I had to make a
modification to function_get_sql_clause to support the MS TOP keyword.
Also had to modify method_save to provi
On 1/10/06, Adrian Holovaty <[EMAIL PROTECTED]> wrote:
>
> On 1/10/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> > Here is the exact SQL that is passed to MS SQL:
> >
> > SELECT
> > [core_sessions].[session_key],[core_sessions].[session_data],[core_sessions].[expire_date]
> > FROM [core_sessions] WH
On 1/10/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> Here is the exact SQL that is passed to MS SQL:
>
> SELECT
> [core_sessions].[session_key],[core_sessions].[session_data],[core_sessions].[expire_date]
> FROM [core_sessions] WHERE [core_sessions].[session_key] = %s
>
> As you can see, it has sto
On Jan 10, 2006, at 10:21 PM, Adrian Holovaty wrote:
On 1/9/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
I am experimenting with Django and MS SQL and it appears that
Django is
passing parameters to MS SQL in an incorrect format.
The params are being passed in as a format string sty
Jeremy Dunck wrote:
Hi Jeremy,
> > The syntax that MS SQL expects:
> > select foo from bar where foo = @fooName
>
> Are we talking about literals or parameters?
I'm talking about parameters.
> That is, are you expecting:
>
> select colname from tablename where colname = 'somevalue'
> or
> sel
Adrian Holovaty wrote:
Hi Adrian,
> Could you paste the entire traceback you get? Also, would any other MS
> SQL users in the audience be able to help?
Here is an entire traceback I get when attempting to access the /admin
site:
Traceback (most recent call last):
File "C:\Python24\lib\site
>total waste of time - foss rulz - let them come to us
There are people having a real job and those might stumble over mssql
servers (I know for sure that I will from time to time) and they might
find it comforting to know that they can continue to use their
framework of choice. And no, they won
Wilson wrote:
Django supporting MSSQL strikes me a bit like iTunes running on
Windows. As in it's a great thing for the platform. If somebody locked
in to a MSSQL environment has the chance to try a real project with
Django and be exposed to great, useful open-source software that
doesn't turn i
On 1/10/06, Jeremy Dunck <[EMAIL PROTECTED]> wrote:
>
> Nonviolence is the way. ;-)
Or, as Voltaire said over 200 years ago:
"The perfect is the enemy of the good."
(Well, okay, maybe he didn't say it in English.) :-p
On Tuesday 10 Jan 2006 10:10 pm, Wilson wrote:
> Django supporting MSSQL strikes me a bit like iTunes running on
> Windows. As in it's a great thing for the platform. If somebody
> locked in to a MSSQL environment has the chance to try a real
> project with Django and be exposed to great, useful o
Django supporting MSSQL strikes me a bit like iTunes running on
Windows. As in it's a great thing for the platform. If somebody locked
in to a MSSQL environment has the chance to try a real project with
Django and be exposed to great, useful open-source software that
doesn't turn its nose up at th
On Tuesday 10 Jan 2006 9:57 pm, Dody Suria Wijaya wrote:
> > Nonviolence is the way. ;-)
> >
>
> +1
>
> $_$
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
On Tuesday 10 Jan 2006 9:46 pm, Jeremy Dunck wrote:
> I'm philosophically in line with much of the Free philosophy, but
> FSF didn't decide not to run on Unix while developing the tools
> to replace it; some compromises are necessary. There exists a
> huge install base locked into MS SQL; denying
Jeremy Dunck wrote:
I'm philosophically in line with much of the Free philosophy, but FSF
didn't decide not to run on Unix while developing the tools to replace
it; some compromises are necessary. There exists a huge install base
locked into MS SQL; denying django to those folks won't help the
On 1/10/06, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> sorry, adrian, i dont agree - there is a limit to pandering to these
> ppl - i think that open source is now powerful enough to start
> demanding that these ppl respect our terms. anyway - i think you
> should spend more time on what you d
On Tuesday 10 Jan 2006 9:24 pm, Adrian Holovaty wrote:
> On 1/10/06, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> > > The majority of users are on SQL Server 2000. A significant
> > > minority are on 7. A tiny minority still use 6.5. And in a
> > > year, a significant minority will be using 2005
On 1/10/06, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> > The majority of users are on SQL Server 2000. A significant
> > minority are on 7. A tiny minority still use 6.5. And in a
> > year, a significant minority will be using 2005.
>
> and which is opensource? and if it is not, why waste our
On Tuesday 10 Jan 2006 9:06 pm, Jeremy Dunck wrote:
> On 1/10/06, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> > and which is opensource? and if it is not, why waste our time?
>
> If you're going to take that position, I think you mean Free.
>
> But we're not wasting your time, we're wasting our
On 1/10/06, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> and which is opensource? and if it is not, why waste our time?
>
If you're going to take that position, I think you mean Free.
But we're not wasting your time, we're wasting ours. Feel free to
ignore the discussion.
On Tuesday 10 Jan 2006 8:39 pm, Jeremy Dunck wrote:
> > best to target the latest open source version
>
> I assume you're being ironic there.
>
> The majority of users are on SQL Server 2000. A significant
> minority are on 7. A tiny minority still use 6.5. And in a
> year, a significant minori
On 1/10/06, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
>
> On Tuesday 10 Jan 2006 8:20 pm, Jeroen Ruigrok van der Werven wrote:
> > Which version of MS SQL do you initially want to target Adrian?
>
> best to target the latest open source version
I assume you're being ironic there.
The majority
On 1/10/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> The syntax that MS SQL expects:
> select foo from bar where foo = @fooName
Are we talking about literals or parameters?
That is, are you expecting:
select colname from tablename where colname = 'somevalue'
or
select colname from tablename whe
On Tuesday 10 Jan 2006 8:20 pm, Jeroen Ruigrok van der Werven wrote:
> Which version of MS SQL do you initially want to target Adrian?
best to target the latest open source version
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
On 1/10/06, Jeroen Ruigrok van der Werven <[EMAIL PROTECTED]> wrote:
> Which version of MS SQL do you initially want to target Adrian? I can
> probably get some basic testing done here to clear the majority of the
> issues.
Thanks for the offer! Knowing next to nothing about MS SQL, I don't
have
On 1/10/06, Adrian Holovaty <[EMAIL PROTECTED]> wrote:
> The Django MS SQL support is still in alpha status, mostly because we
> don't have many people who've tried to use it with MS SQL. We're very
> keen on getting that driver up to speed, though, and you can help.
Which version of MS SQL do you
Hi Russ,
Thanks for th tip on where to splunk for the offending code.
The SQL that is arriving at the sever is in the folowing format:
select foo from bar where foo = %sfooName
The query parser dies at %s with an invalid syntax exception...
The syntax that MS SQL expects:
select foo from bar w
On 1/9/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> I am experimenting with Django and MS SQL and it appears that Django is
> passing parameters to MS SQL in an incorrect format.
>
> The params are being passed in as a format string style (%s), which MS
> SQL chokes on.
Hey
On 1/10/06, Rich Bakos <[EMAIL PROTECTED]> wrote:
> The params are being passed in as a format string style (%s), which MS
> SQL chokes on.
Can you clarify exactly what you mean here? What SQL are you getting,
and what are you expecting (or what would work)?
If you feel like having a poke around
I am experimenting with Django and MS SQL and it appears that Django is
passing parameters to MS SQL in an incorrect format.
The params are being passed in as a format string style (%s), which MS
SQL chokes on.
Is anyone here using MS SQL that might be able to shed some light on
this problem
49 matches
Mail list logo
