aws-sdk-pandas icon indicating copy to clipboard operation
aws-sdk-pandas copied to clipboard

Swap JDBC for Arrow ADBC

Open jaidisido opened this issue 3 years ago • 3 comments

Leveraging the Arrow ADBC Driver has a number of advantages:

  • A single, universal driver would replace all existing, proprietary drivers (mssql, postgres...)
  • Better performance due to not processing each row separately and tapping into pyarrow to avoid serialization/deserialization

Additional context https://arrow.apache.org/docs/dev/format/ADBC.html

P.S. Please do not attach files as it's considered a security risk. Add code snippets directly in the message body as much as possible.

jaidisido avatar Nov 09 '22 18:11 jaidisido

The implementation for this is in progress for Postgresql (see development branch). However, we are currently blocked by this bug in Pandas: https://github.com/pandas-dev/pandas/issues/57539

LeonLuttenberger avatar Mar 01 '24 20:03 LeonLuttenberger

Marking this issue as stale due to inactivity. This helps our maintainers find and focus on the active issues. If this issue receives no comments in the next 7 days it will automatically be closed.

github-actions[bot] avatar Apr 30 '24 21:04 github-actions[bot]

Marking this issue as stale due to inactivity. This helps our maintainers find and focus on the active issues. If this issue receives no comments in the next 7 days it will automatically be closed.

github-actions[bot] avatar Jun 30 '24 18:06 github-actions[bot]