pypyodbc 1.1.3

PyPyODBC - A Pure Python ODBC module by ctypes

Home Page

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

  A DBI 2.0 SQLAlchemy enabler driver for IronPython

  A DBI 2.0 SQLAlchemy enabler driver for *PyPy*

Install

• pip install pypyodbc

History

Version 1.1.5 July 11 2013

• Fix Issue 18: Reuse of prepared statement

Version 1.1.3 July 8 2013

• Speed improvements and Python 3.x fixes

Version 1.1.2 Apr 10 2013

• Automatically detect and use installed Access driver on Windows.

Version 1.1.1 Apr 4 2013

• Now you can reference a field of the fetched row by row[‘a field’]

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;