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

What is 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.

Overview of turbodbc

What it is

Turbodbc is a Python module that provides access to relational databases through the Open Database Connectivity (ODBC) interface. It complies with the Python Database API Specification 2.0 (PEP 249) for maximum compatibility. The module is designed primarily for data scientists who work with databases that lack efficient native Python drivers. Turbodbc is free to use under the MIT license, open source on GitHub, and supports Python 3.9 and later on Linux, macOS, and Windows.

Key features

  • Complies with Python Database API Specification 2.0 (PEP 249)
  • Built-in support for NumPy and Apache Arrow for high-performance data transfer
  • Uses batched data transfer internally instead of single-record communication, improving performance over other ODBC modules
  • Routinely tested with MySQL, PostgreSQL, EXASOL, and MSSQL, and likely works with other databases
  • Cross-platform availability (Linux, macOS, Windows)

Use cases

Turbodbc is suitable for data scientists and analysts who need to query relational databases via ODBC, especially when native Python drivers are not available or efficient. It can be used for data extraction, transformation, and loading (ETL) workflows, as well as for integrating database query results directly into NumPy or Apache Arrow pipelines.

Getting started

See the repository README for installation instructions and quick-start guidance.

License and pricing

Turbodbc is released under the MIT license and is open source. No pricing information is provided; it is free to use.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/blue-yonderturbodbc.svg)](https://yunodb.com/tools/blue-yonderturbodbc?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/blue-yonderturbodbc?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/blue-yonderturbodbc.svg" alt="Featured on YunoDB" height="20"></a>