vinum
turbodbc
| vinum | turbodbc | |
|---|---|---|
| 5 | 2 | |
| 65 | 603 | |
| - | 0.0% | |
| 0.0 | 8.0 | |
| almost 3 years ago | 6 days ago | |
| C++ | C++ | |
| BSD 3-clause "New" or "Revised" License | MIT License |
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.
vinum
-
Practical SQL for Data Analysis(what you can do without Pandas)
Following similar observations I was wondering if one can actually execute SQL queries inside of Python process with the access to native Python functions and Numpy as UDFs. Thanks to Apache Arrow one can mix C++ and Python operators without need to copy the data and essentially combine DataFrame API with SQL, all while within the confines of the same Python process.
https://github.com/dmitrykoval/vinum
Vinum allows users to write queries which may invoke any Numpy or Python functions as UDFs available to the interpreter.
- Vinum is a SQL query processor for Python, designed for data analysis workflows
- dmitrykoval/vinum Vinum is a SQL query processor for Python, designed for data analysis workflows and in-memory analytics.
- Vinum – SQL Processor for Python with native Python, Numpy UDF support.
- Show HN: Vinum – SQL Processor for Python with Native Python, Numpy UDF Support
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.
What are some alternatives?
siuba - Python library for using dplyr like syntax with pandas and SQL
arrow-odbc-py - Read Apache Arrow batches from ODBC data sources in Python
NumCpp - C++ implementation of the Python Numpy library
soci - Official repository of the SOCI - The C++ Database Access Library
datatable - A Python package for manipulating 2-dimensional tabular data structures
pyexasol - Exasol Python driver with low overhead, fast HTTP transport and compression
duckdb - DuckDB is an in-process SQL OLAP Database Management System
Pytorch - Tensors and Dynamic neural networks in Python with strong GPU acceleration
q - q - Run SQL directly on delimited files and multi-file sqlite databases
arrow2 - Transmute-free Rust library to work with the Arrow format
odbc - Connect to ODBC databases (using the DBI interface)