fire-eggs / fire-eggs/Danbooru2021

Paging is best done using fetchmany()

Open
#46 1 comment 0 reactions 0 assignees View on GitHub
database enhancement
Dominant language
Python
Stars
42
Forks
2
PR merge metrics
No merged PRs in 30d

Description

Python sqlite has a `fetchmany` operation which would be the easiest way to do paging.

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue identifies Python sqlite's fetchmany operation as the intended paging entry point but names no file or test. Locate the current paging and query code, compare its behavior with fetchmany(), and verify that paging still returns the expected records.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlite
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.