|
Size: 3504
Comment: wiki restore 2013-01-23
|
← Revision 54 as of 2017-08-07 22:47:25 ⇥
Size: 5346
Comment: Replaced some code.google.com links with current links.
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| Line 3: | Line 2: |
ODBC stands for ''Open Database Connectivity'', the industry standard for database C APIs. |
WikiPedia:ODBC stands for ''Open Database Connectivity'', the industry standard for database C APIs. |
| Line 10: | Line 6: |
| Since all ODBC Python interfaces need ODBC drivers to connect to the databases, we're hosting a [[ODBCDrivers|list of ODBC drivers]] on a separate page. | |
| Line 13: | Line 10: |
| == DB API 2.0 Drivers == === mxODBC === URL:: http://www.egenix.com/products/python/mxODBC/ License:: eGenix Commercial License 1.3.0 Platforms:: Windows, Unix, Mac OS X, FreeBSD, Solaris, AIX, other platforms on request Python versions:: 2.4 - 2.7 |
|
| Line 14: | Line 17: |
| Commercially supported fully DB-API 2.0 compliant ODBC database interface from eGenix.com; actively maintained since 1997. | |
| Line 15: | Line 19: |
| mxODBC comes with full support for stored procedures, multiple result sets, Unicode, a common interface on all platforms and [[http://www.egenix.com/products/python/mxODBC/#Features|many other useful features]]. | |
| Line 16: | Line 21: |
| == DB API 2.0 Drivers == === mxODBC === URL:: http://www.egenix.com/products/python/mxODBC/ License:: eGenix Commercial License 1.3.0 Platforms:: Windows 32/64-bit, Linux 32/64-bit, MacOS X 10.4-10.6 32/64-bit, FreeBSD 32/64-bit, Solaris, AIX Python versions:: 2.3 - 2.7 Commercially supported ODBC database interface from eGenix.com; actively maintained since 1997. Supports Windows, Mac OS X, iODBC, unixODBC and [[DataDirect|DataDirect]] ODBC driver managers. Is known to work with these ODBC drivers: MS SQL Server Native Client, MS SQL Server ODBC Driver, FreeTDS ODBC Driver, Oracle Instant Client ODBC Driver, IBM DB2 ODBC Driver, Sybase ASE ODBC Driver, Netezza ODBC Driver, Teradata ODBC Driver, PostgreSQL ODBC Driver, MySQL ODBC Driver, .MaxDB ODBC Driver as well as the ODBC driver sets of [[EasySoft|EasySoft]], [[DataDirect|DataDirect]], [[OpenLink|OpenLink]], Actual Technologies. |
Supports Windows, Mac OS X, iODBC, unixODBC and !DataDirect ODBC driver managers. Is known to work with these ODBC drivers: MS SQL Server Native Client, MS SQL Server ODBC Driver, FreeTDS ODBC Driver, Oracle Instant Client ODBC Driver, IBM DB2 ODBC Driver, Sybase ASE ODBC Driver, Netezza ODBC Driver, Teradata ODBC Driver, PostgreSQL ODBC Driver, MySQL ODBC Driver, .MaxDB ODBC Driver as well as the ODBC driver sets of !EasySoft, !DataDirect, !OpenLink, Actual Technologies. |
| Line 37: | Line 24: |
URL:: http://code.google.com/p/pyodbc |
URL:: https://github.com/mkleehammer/pyodbc Documentation:: https://github.com/mkleehammer/pyodbc/wiki |
| Line 44: | Line 28: |
| Python versions:: 2.4 - 3.2 |
Python versions:: 2.7 - 3.6 |
| Line 49: | Line 32: |
| Precompiled binary wheels are available for Windows and macOS for Python 2.7 and 3.4+, installable using `pip install pyodbc`. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories. |
|
| Line 50: | Line 35: |
| Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories. | === turbodbc === URL:: https://github.com/blue-yonder/turbodbc License:: MIT Platforms:: Linux, OSX (Mac OS), Windows; all platforms 64-bit Python versions:: 2.7, 3.4, 3.5, 3.6 (tested versions, other versions may work as well) |
| Line 52: | Line 41: |
| Actively maintained Open Source project. Turbodbc offers turbocharged database access for data scientists. It heavily relies on buffered I/O for maximum performance, and comes with built-in (optional) NumPy support. |
|
| Line 54: | Line 46: |
URL:: http://ceodbc.sourceforge.net |
URL:: http://ceodbc.sourceforge.net |
| Line 63: | Line 51: |
| Line 65: | Line 52: |
URL:: http://www.egenix.com/products/python/mxODBCConnect/ |
URL:: http://www.egenix.com/products/python/mxODBCConnect/ |
| Line 71: | Line 54: |
| Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX | Platforms:: Client: all Python platforms; Server: Windows, Linux |
| Line 73: | Line 56: |
| Line 77: | Line 59: |
| mxODBC Connect supports asynchronous query execution via the popular [[http://www.gevent.org/|gevent package]], provides secure certificate based authentication, SSL encrypted database connections, comes with full support for stored procedures, multiple result sets, Unicode, a common interface on all platforms and implements [[http://www.egenix.com/products/python/mxODBCConnect/#Features|many other useful features]]. | |
| Line 80: | Line 63: |
The 2.0 release also supports asynchronous query execution via the popular [[http://www.gevent.org/|gevent package]]. |
|
| Line 85: | Line 64: |
URL:: http://benjiyork.com/odbtp.html |
URL:: http://benjiyork.com/odbtp.html |
| Line 94: | Line 69: |
| === PyPyODBC (Pure Python) === URL:: https://github.com/jiangwen365/pypyodbc License:: MIT Platforms:: Windows, Linux Python versions:: 2.4 - 3.3 |
|
| Line 95: | Line 75: |
| === PyPyODBC === | [[http://code.google.com/p/pypyodbc/wiki/A_HelloWorld_sample_to_access_mssql_with_python|A Hello World script of pypyodbc database programing]] |
| Line 97: | Line 77: |
| [[http://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file|Built-in Access MDB file creation and compression functions on Windows.]] | |
| Line 98: | Line 79: |
| URL:: http://code.google.com/p/pypyodbc |
[[http://code.google.com/p/pypyodbc/wiki/Enable_SQLAlchemy_on_IronPython|A DBI 2.0 SQLAlchemy enabler driver for IronPython]] [[https://code.google.com/p/pypyodbc/wiki/Enable_SQLAlchemy_on_PyPy|And PyPy]] |
| Line 101: | Line 81: |
| License:: MIT Platforms:: Windows, Any (source provided) Python versions:: 2.6 - 2.7 |
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. |
| Line 105: | Line 83: |
| Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ). | |
| Line 106: | Line 85: |
| * Pure Python, compatible with [[IronPython|IronPython]] and [[PyPy|PyPy]] (tested on Win32) * Almost totally same usage as pyodbc |
Simple - the whole module is implemented in a single python script with less than 3000 lines. |
| Line 112: | Line 89: |
| Line 116: | Line 90: |
| Line 119: | Line 91: |
URL:: http://python.net/crew/mhammond/win32/ |
URL:: http://python.net/crew/mhammond/win32/ |
| Line 128: | Line 96: |
ODBC
ODBC stands for Open Database Connectivity, the industry standard for database C APIs.
Most databases ship with ODBC drivers, so chances are high that you can use one of these drivers together with a Python ODBC interface to connect your Python application with any database on the market.
Since all ODBC Python interfaces need ODBC drivers to connect to the databases, we're hosting a list of ODBC drivers on a separate page.
DB API 2.0 Drivers
mxODBC
- URL
- License
- eGenix Commercial License 1.3.0
- Platforms
- Windows, Unix, Mac OS X, FreeBSD, Solaris, AIX, other platforms on request
- Python versions
- 2.4 - 2.7
Commercially supported fully DB-API 2.0 compliant ODBC database interface from eGenix.com; actively maintained since 1997.
mxODBC comes with full support for stored procedures, multiple result sets, Unicode, a common interface on all platforms and many other useful features.
Supports Windows, Mac OS X, iODBC, unixODBC and DataDirect ODBC driver managers. Is known to work with these ODBC drivers: MS SQL Server Native Client, MS SQL Server ODBC Driver, FreeTDS ODBC Driver, Oracle Instant Client ODBC Driver, IBM DB2 ODBC Driver, Sybase ASE ODBC Driver, Netezza ODBC Driver, Teradata ODBC Driver, PostgreSQL ODBC Driver, MySQL ODBC Driver, .MaxDB ODBC Driver as well as the ODBC driver sets of EasySoft, DataDirect, OpenLink, Actual Technologies.
pyodbc
- URL
- Documentation
- License
- MIT
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
- Python versions
- 2.7 - 3.6
Actively maintained Open Source project.
Precompiled binary wheels are available for Windows and macOS for Python 2.7 and 3.4+, installable using pip install pyodbc. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.
turbodbc
- URL
- License
- MIT
- Platforms
- Linux, OSX (Mac OS), Windows; all platforms 64-bit
- Python versions
- 2.7, 3.4, 3.5, 3.6 (tested versions, other versions may work as well)
Actively maintained Open Source project.
Turbodbc offers turbocharged database access for data scientists. It heavily relies on buffered I/O for maximum performance, and comes with built-in (optional) NumPy support.
ceODBC
- URL
- License
- Platforms
- Windows
- Python versions
mxODBC Connect
- URL
- License
- eGenix Commercial License 1.3.0
- Platforms
- Client: all Python platforms; Server: Windows, Linux
- Python versions
- 2.5 - 2.7
mxODBC Connect is a commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side. The product uses mxODBC on the server side and provides a highly portable Python library for the client side. As such it supports all database backend that mxODBC supports, but allows connecting to these from many different Python-supported platforms.
mxODBC Connect supports asynchronous query execution via the popular gevent package, provides secure certificate based authentication, SSL encrypted database connections, comes with full support for stored procedures, multiple result sets, Unicode, a common interface on all platforms and implements many other useful features.
For ODBC drivers supported on the server side, please see the mxODBC entry.
ODBTPAPI
- URL
- License
- Platforms
- Python versions
PyPyODBC (Pure Python)
- URL
- License
- MIT
- Platforms
- Windows, Linux
- Python versions
- 2.4 - 3.3
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 And PyPy
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.
DB API 1.0 Drivers
win32 odbc module (part of pywin32 package)
- URL
- License
- PSF and others
- platforms
- Windows
- Python versions
- 2.3 - 3.2
This interface is rather old, mostly unmaintained and only provides an DB-API 1.0 interface, but listed here since it started the Python DB-API specification development back in 1996.