search

blue-yonder / turbodbc

Turbodbc is a Python module to access relational databases via the Open Database Connectivity (ODBC) interface. The module complies with the Python Database API Specification 2.0.
http://turbodbc.readthedocs.io/en/latest
MIT License
623 stars 85 forks source link
data-science database exasol numpy odbc pep249 pyodbc python python-database-api speedup

readme

turbodbc logo

Turbodbc - Turbocharged database access for data scientists.

Build Status Documentation Status codecov Anaconda-Server Badge Anaconda-Server Badge

Turbodbc is a Python module to access relational databases via the Open Database Connectivity (ODBC) interface. Its primary target audience are data scientists that use databases for which no efficient native Python drivers are available.

For maximum compatibility, turbodbc complies with the Python Database API Specification 2.0 (PEP 249). For maximum performance, turbodbc offers built-in NumPy and Apache Arrow support and internally relies on batched data transfer instead of single-record communication as other popular ODBC modules do.

Turbodbc is free to use (MIT license), open source (GitHub), works with Python 3.9+, and is available for Linux, macOS, and Windows.

Turbodbc is routinely tested with MySQL, PostgreSQL, EXASOL, and MSSQL, but probably also works with your database.

Nice! Where can I find documentation?

Follow this link to the latest turbodbc documentation. The documentation explains how to install and use turbodbc, and also provides answers to many questions you might have.

Is turbodbc on Twitter?

Yes, it is! Just follow @turbodbc for the latest turbodbc talk and news about related technologies.