How to fetch data from db in sqlite queue?

Question

Python

How on pressing of the button next to me to take record from a DB? Before that, a person puts filters. I tried, when requested, to put all the id of the pets in the list and take them in turn, but I didn’t succeed, in general, what are your ideas?

Answer 1

Store the state for each user - which filters are set, which position in the list was viewed last.
To select data from the database starting from this position, sort the data and use OFFSET and LIMIT. This will not guarantee that any new elements will not be skipped, but it is a very simple implementation. You store OFFSET for the user, and about clicking "next" you increase it by LIMIT.