Make cursor scrollable

Open
#835 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
48/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Quiet
Tech stack
python
Domain
database

Research direction

Start with the linked python-oracledb scrollable-cursor documentation, then locate the connector's cursor object and its server request path. Determine how a forward scroll by X rows can be sent without fetching and transferring those rows. Done means the cursor supports that operation and its behavior is covered by the relevant existing tests.

Written by the indexing model from the issue text.

Description

Make the cursor object scrollable so we can tell the server to scroll forward X rows without having to do a fetchmany(X) and have to do a transfer of data for those rows. For example here is how it used in the oracle db connector

https://python-oracledb.readthedocs.io/en/latest/user_guide/sql_execution.html#scrollablecursors

Dominant language
Python
Stars
233
Forks
152
Avg merge
21h 5m
Merged PRs (30d)
10

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from databricks/databricks-sql-python

All issues in databricks/databricks-sql-python

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.