You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@arrow.apache.org by GitBox <gi...@apache.org> on 2022/08/19 18:27:44 UTC

[GitHub] [arrow-adbc] lidavidm opened a new issue, #72: [C] Research Turbodbc/Arrowdantic for developing ODBC-wrapping driver

lidavidm opened a new issue, #72:
URL: https://github.com/apache/arrow-adbc/issues/72

   Arrowdantic: https://github.com/jorgecarleitao/arrowdantic/
   Turbodbc: https://github.com/blue-yonder/turbodbc/


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-adbc] pacman82 commented on issue #72: [C] Research Turbodbc/Arrowdantic for developing ODBC-wrapping driver

Posted by GitBox <gi...@apache.org>.

pacman82 commented on issue #72:
URL: https://github.com/apache/arrow-adbc/issues/72#issuecomment-1226381257

Hi there 👋 . I am the author of `arrow-odbc` and a typo braught me here. A quick heads up:

Turbodbc:
- Uses ODBC C Interface directly from C++ and fills arrow (C++ official implementation) arrays in C++.
- `pyarrow` is backed by the C++ arrow implementation. Python C API is used for interfacing
- For all things to work together, C++ ABI, Python C-API, boost version, arrow version must match. Somewhat frickle build process.
- Scope: Complies with [Python Database API Specification 2.0 (PEP 249)](https://www.python.org/dev/peps/pep-0249/)

Arrowdantic (at the best of my knowledge):
- Uses ODBC from a Rust crate (odbc-api) which and fills arrow2(Rust crate) arrays directly in Rust
- Provides Python bindings for `arrow2`.
- Scope: More an alternative to `pyarrow` with built-in ODBC support

arrow-odbc
- Uses ODBC from a Rust crate (odbc-api) which talks to Python via C-Interface.
- Uses arrow (Rust crate, official implementation) and Arrow-C Interface to interface with `pyarrow`
- Scope: Read and write `pyarrow` arrays with ODBC from and to databases.

Cheers,
Markus

--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-adbc] pacman82 commented on issue #72: [C] Research Turbodbc/Arrowdantic for developing ODBC-wrapping driver

Posted by GitBox <gi...@apache.org>.

pacman82 commented on issue #72:
URL: https://github.com/apache/arrow-adbc/issues/72#issuecomment-1226422650

   > Hi, sorry for typosquatting 🙂
   
   I don't mind.
   
   > Also, the plan would be to use [nanoarrow](https://github.com/apache/arrow-nanoarrow) to avoid bringing in dependencies on libarrow, Boost, or anything like that.
   
   Yeah, building that is a pain. Personally I would recommend using one of the Rust implementations (either `arrow` or `arrow2`), since Rust links everything static by default, and `cargo` is way more fun than any C/C++ based build system. You do you, though.
   
   Cheers, Markus


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-adbc] lidavidm commented on issue #72: [C] Research Turbodbc/Arrowdantic for developing ODBC-wrapping driver

Posted by GitBox <gi...@apache.org>.

lidavidm commented on issue #72:
URL: https://github.com/apache/arrow-adbc/issues/72#issuecomment-1226395388

   Hi, sorry for typosquatting :slightly_smiling_face: 
   
   Thanks for the breakdown! The scope here would be lower level than any of these. I suppose I'm mostly curious about how each project achieves their speed objectives. Also, the plan would be to use [nanoarrow](https://github.com/apache/arrow-nanoarrow) to avoid bringing in dependencies on libarrow, Boost, or anything like that.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-adbc] pacman82 commented on issue #72: [C] Research Turbodbc/Arrowdantic for developing ODBC-wrapping driver

Posted by GitBox <gi...@apache.org>.

pacman82 commented on issue #72:
URL: https://github.com/apache/arrow-adbc/issues/72#issuecomment-1226424171

   > Yeah, building that is a pain
   
   To clarify: I was referring the dependencies. I've no experience or knowledge about/with nanoarrow.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org