The Pure Python ODBC Library PYPYODBC 1.0 is released, and the new version is compatible with both python2.x and Python3.3.
PYPYODBC is a Python ODBC library that can be seen as a pure Python implementation of the famous Pyodbc library, and they are almost identical in their usage--like the PyPy Python cottage python, Pypyodbc used Python to cottage the PYODBC.
and the nature of pure Python-based code brings great compatibility, embedding and code portability to the PYPYODBC library--PYPYODBC can run under Cpython,ironpython and PyPy VMs and can run under Windows,linux platforms, Can be run in Python 3.3, 2.4, 2.5, 2.6, 2.7, and so on, can be embedded in the project without the need for additional compilation and installation of Python ODBC library modules in the running environment.
Other Highlights:
Simple and lightweight-the PYPYODBC library has only one Python script file and no more than 3000 lines of code. You can easily embed it into your project.
Built-in Access MDB support-on the Windows platform, PYPYODBC can create an Access database on its own without installing the Microsoft Office suite.
code example
Import Pypyodbcpypyodbc.win_create_mdb (' D:\\database.mdb ') connection_string = ' Driver={microsoft Access Driver (*. MDB)};D bq=d:\\database.mdb ' connection = Pypyodbc.connect (connection_string) SQL = ' CREATE TABLE saleout (ID COUNTER PRIMARY key,product_name VARCHAR) ' Connection.cursor (). Execute (SQL) ...
Trial PYPYODBC
If you have a script that uses PYODBC, if you want to try the Pypyodbc effect, all you have to do is comment out one line of code in the script and replace it with another line of code, like this:
#import Pyodbcimport Pypyodbc as Pyodbc