-
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.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
arrow-odbc-py provides ready to use, pip installable wheels for fetching from ODBC sources into arrow arrays.
turbodbc is great, but a pain to build, at least without conda. arrow-odbc-py uses cffi (rather than PyO3) to talk to a rust backend and than uses the Arrow C Data interface to provide the user with pyarrow compatible arrow arrays. The use of a dedicated C interface in both places, avoids linking directly against the Python C-Interpreter as well as the specific C++ Arrow libraries your pyarrow version depends on. Avoiding some pain of dependency hell.
Related posts
-
A smooth and sharp image interpolation you probably haven't heard of
-
Open-source SDK for adding custom code interpreters to AI apps
-
Show HN: SpRAG – Open-source RAG implementation for challenging real-world tasks
-
Show HN: Local GLaDOS
-
Let's Build An AI Agent: trendrBOT answers questions about Google Search trends