How do I browse a database ?

[Quoted] [Quoted] Some time ago I tried to create a program to browse the contents of a random [Quoted] SQL database.

The problem is that I could not find a dependable* method to get the next or previous screen full of records - while keeping resource-usage (for both the database as well as the program) low**.

Is there a standard way to do it, and if so what is it*** ?

*The "just send all the data of a specific record back and have it return up
or down sorted records from there" doesn't quite work when that retrieved / send back (subset of) data is not all that unique (think: excluding stuff like binary blobs).

**Creating a temporary DB with just the 'unique key' column is ofcourse a
possibility, but that takes quite a bit of memory/disk (even when assuming its just a 32 bit value).

***The "skip {x} records from the start" method seems to be heavily
discouraged.

Regards,
Rudy Wieser

P.s.
[Quoted] In all honesty, I'm using SQLite. But as I could not find a newsgroups specific for it ... Received on Wed Aug 07 2019 - 12:26:19 CEST