is anyone aware of testing tools that we might use to evaluate the reliability under load of SQLAlchemy + FreeTDS + pymssql on a debian-stable platform accessing an MS SQL Server?
unfortunately i can't choose the DB, but i'm really hoping to use python on a linux application server for our future applications. we've already done some considerable work in this direction, and it would be discouraging if (eg) the FreeTDS driver weren't reliable under load. thanks Rick Morrison wrote: > > can you expand on this? i intend to use pymssql / freetds for writing > production applications, though i haven't used them before. > > > Us too, though we have used them before. FWIW, they have been working > problem-free for over 2 years, though in a low-volume environment. > > > is there no way to confidently access ms sql servers from a > python-on-*n*x application platform? > > > I've been doing a bit of research on this over the last couple of days. > The more research I do into this, the more it appears that just about > every open source interface that talks to either Sybase or mssql from > *nix platforms in fact uses FreeTDS under the covers, including mxODBC, > Perl's DBI/DBD, and most of the *nix ODBC projects. So maybe it's not as > risky as I thought. > > There are also some commercially supported non-FreeTDS ODBC drivers, but > I know of no Python DBAPI modules for them: > > http://www.datadirect.com/products/odbc/odbcoverview/index.ssp > http://www.openlink.co.uk/ > > I hope all this helps more than confuses. Let me know what you find in > your research. I am keenly interested in this. > > Rick > > PS - Hey I'm a UConn grad....Go Huskies! > > > > > > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > <mailto:Sqlalchemy-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > <https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users> > > _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
