PyPyODBC - A Pure Python ODBC module by ctypes
Project description
Features
One pure Python script, runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 / 3.2 / 3.3, Win / Linux , 32 / 64 bit.
Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ).
Simple - the whole module is implemented in a single python script with less than 3000 lines.
A Hello World script of pypyodbc database programing
Built-in Access MDB file creation and compression functions on Windows
- Install
pip install pypyodbc
History
- Version 1.1.0 Apr 3 2013
Better None value handling in a Binary Parameter;
Added a get() method for Row object, with which you can reference by column name;
Bugs fix for prepare statement;
- Version 1.0.9 Mar 18 2013
Fix several bugs under Python 3.x;
Add Mac / iODBC platform support
Improved ODBC ANSI / unicode mode support;
Fix the error when None value is in a parameter
- Version 1.0.0 Feb 21 2013
PyPyODBC now is compatibly with Python 3.3
- Version 0.9.3 Feb 9 2013
pypyodbc now use better approach to find the ODBC library on Linux
- Version 0.9.2 Feb 3 2013
pypyodbc now can run under Python 2.4 (with the non-built-in ctypes lib)
Better parameters type conversion detection
Raise exception for creating/compact mdb file failure and call from non-windows platforms
- Version 0.9.1 Jan 13 2013
pypyodbc now can run under Python 2.5; Thanks Chris Clark for the patch :)
- Version 0.9.0 Jan 11 2013
Enhance multi-threaded, 64-bit environment with Linux (wide Python build) and unixODBC; Thanks Sok Ann Yap for those patches :);
- Version 0.8.7 Oct 18 2012
Added output converter function;
Fix result description;
Cursor iteration protocol;
Accept connection string in parameters format;
- Version 0.8.6 Sep 23 2012
Added ODBC pooling feature
Bit, GUID type support
Other fixes and improvements
- Version 0.8.5 Sep 16 2012
Numeric type fix
Long and integer differentiate
Other pyodbc compatibility improvements;
- Version 0.8.4 Sep 09 2012
Improved compatibility with pyodbc
Many underlying bug fixes;
- Version 0.8.3 Sep 01 2012
sql_longvarchar handling fix;
Performance optimization;
- Version 0.8.2 Aug 27 2012
Differentiate sql_varchar and sql_longvarchar;
Initial support for SQLAlchemy;
- Version 0.8.1 Aug 26 2012
Fixed the long type parameter issue;
Added IronPython in the supported platform
- Version 0.8 Aug 25 2012
Added getinfo method;
- Version 0.7 Jul 28 2012
Fixed text/ntext issues;