I would like to be able to page through a result set when there is more than one screenful of data. Is there a good example of paging through a query result set in Bash - something like implementing the less command? Even if I can't scroll backwards through the result set, at least being able to control the paging forward would be good.
I have seen the notes on fetchmany(), which almost seems to be what I want. Except that fetchmany(25) will fetch 25 records and that's about it. Maybe I just need to change the way I code it...
But I am not certain it really does what I am looking for. Still, I am fairly certain there is an example of this somewhere I can look at to see how it is implemented.