turbodbc
odbc
turbodbc | odbc | |
---|---|---|
2 | 2 | |
603 | 378 | |
0.0% | 0.0% | |
8.0 | 9.0 | |
3 days ago | 7 days ago | |
C++ | C++ | |
MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
turbodbc
-
Arrowdantic 0.1.0 released
It supports reading from and writing to ODBC compliant databases at likely similar performance as turbodbc and it does not require conda to install.
-
arrow-odbc: Fetch arrow arrays from an ODBC data source in a pip installable environment
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.
odbc
-
Importing data from SQL into R, with correct R data types
Note: Updating my driver to a newer version improved obtaining the correct data types in the R data frame. There is more about this at https://github.com/r-dbi/odbc/issues/11
-
RODBCext odbc query_timeout
Previously the RODBCext package provided an option to set the query timeout. As of 2020 the package is deprecated and the better alternative is odbc (cran).
What are some alternatives?
arrow-odbc-py - Read Apache Arrow batches from ODBC data sources in Python
nanodbc - A small C++ wrapper for the native C ODBC API | Requires C++14 since v2.12
soci - Official repository of the SOCI - The C++ Database Access Library
RODBCext
vinum - Vinum is a SQL processor for Python, designed for data analysis workflows and in-memory analytics.
pyodbc - Python ODBC bridge
pyexasol - Exasol Python driver with low overhead, fast HTTP transport and compression
Pytorch - Tensors and Dynamic neural networks in Python with strong GPU acceleration
accessDBwE - Golang Microsoft Access Driver Add-On supporting decoding without password
arrow2 - Transmute-free Rust library to work with the Arrow format
Apache Arrow - Apache Arrow is a multi-language toolbox for accelerated data interchange and in-memory processing