Re: How do I browse a database ?

On 8/7/2019 6:26 AM, R.Wieser wrote:
> Hello all,
>
> Some time ago I tried to create a program to browse the contents of a random
> 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.
> In all honesty, I'm using SQLite. But as I could not find a newsgroups
> specific for it ...
>
>
>

SQLite and MySQL are not compatible in a lot of areas. There are extensions to MySQL which help support such operations, but like most databases these are extensions to the SQL specification which may or may not be supported by SQLite.

I don't know of any newsgroups for SQLite and am not real familiar with [Quoted] it but what little I know about it what's available in MySQL will probably NOT work in SQLite.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================