From c1b7c2db1970dcbbe084b5ec29ab8024ccd14c2b Mon Sep 17 00:00:00 2001 From: Marc Abramowitz Date: Thu, 27 Feb 2014 18:45:31 -0800 Subject: [PATCH] Update pymssql dialect description, remove "limitations" section --- lib/sqlalchemy/dialects/mssql/pymssql.py | 25 +++++++++++++++--------- 1 file changed, 16 insertions(+), 9 deletions(-) diff --git a/lib/sqlalchemy/dialects/mssql/pymssql.py b/lib/sqlalchemy/dialects/mssql/pymssql.py index 58b32b10ef..0d016dcaf5 100644 --- a/lib/sqlalchemy/dialects/mssql/pymssql.py +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py @@ -11,15 +11,22 @@ :connectstring: mssql+pymssql://:@?charset=utf8 :url: http://pymssql.org/ -Limitations ------------ - -pymssql inherits a lot of limitations from FreeTDS, including: - -* no support for multibyte schema identifiers -* poor support for large decimals -* poor support for binary fields -* poor support for VARCHAR/CHAR fields over 255 characters +pymssql is a Python module that wraps FreeTDS (a C library) and provides a +DB-API interface, which this dialect uses. + +The 1.x versions of pymssql were written mostly in C, with a Python "outer +layer". These 1.x versions are no longer maintained. + +The 2.x versions of pymssql are written completely in Cython so the code is +translated into C, which is compiled, leading to better performance. The 2.x +versions have had a good amount of development activity in 2013, and so far +this has continued in 2014. pymssql 2.x supports Python 2.6, Python 2.7, and +Python 3.3 and up. + +Note that if you experience problems or limitations when using this dialect, +the problem could be in the dialect, in pymssql, or in FreeTDS (or it could +even be a limitation of SQL Server). So it would be great if you could isolate +the problem before filing tickets with these projects. Please consult the pymssql documentation for further information. -- 2.47.3