diff options
| author | Marc Abramowitz <marc@marc-abramowitz.com> | 2014-02-27 18:45:31 -0800 |
|---|---|---|
| committer | Marc Abramowitz <marc@marc-abramowitz.com> | 2014-02-27 18:45:31 -0800 |
| commit | c1b7c2db1970dcbbe084b5ec29ab8024ccd14c2b (patch) | |
| tree | fd319e6bb7c6eb6c5e0daa708a06284dbe4f3d9c /lib/sqlalchemy/dialects/mssql/pymssql.py | |
| parent | 078621494eb9981733412446aa4eabd9bc54fa52 (diff) | |
| download | sqlalchemy-c1b7c2db1970dcbbe084b5ec29ab8024ccd14c2b.tar.gz | |
Update pymssql dialect description, remove "limitations" section
Diffstat (limited to 'lib/sqlalchemy/dialects/mssql/pymssql.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/pymssql.py | 25 |
1 files changed, 16 insertions, 9 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/pymssql.py b/lib/sqlalchemy/dialects/mssql/pymssql.py index 58b32b10e..0d016dcaf 100644 --- a/lib/sqlalchemy/dialects/mssql/pymssql.py +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py @@ -11,15 +11,22 @@ :connectstring: mssql+pymssql://<username>:<password>@<freetds_name>?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. |