Re: [sqlite] [OT] How to implement paging

Hello Sam, SC> I take it that there is no solution to my problem? That's our job isn't it? Designing some solution that works? - Might have a worker thread watching the DB and have it sending notifications to the GUI as deletes and additions were made to the DB so, the display would be updated

Re: [sqlite] [OT] How to implement paging

On 25 May 2009, at 7:42pm, Sam Carleton wrote: > So in the end, you are saying that it is completely and totally the > responsibility of the frontend to keep track of the page number, > correct? The result set should simply return a total count so that > the # of pages can be calculated.

Re: [sqlite] [OT] How to implement paging

I understand and agree that things changing in the middle is not ideal. In the situation I am dealing with, things MUST disappear in the middle of the dataset. As far as adding things, it should happen at the end, but that is outside of my control, it all depends on how things are sorted.

Re: [sqlite] [OT] How to implement paging

Hello Sam, Are you planning on periodically updating the display as the user interacts with it? Have items pop in and pop out again as they're added or deleted? From your description, the data displayed in the GUI will go stale very quickly. I actually have similar logic in my app and I always

Re: [sqlite] [OT] How to implement paging

On Mon, May 25, 2009 at 4:05 PM, Teg wrote: > Hello Sam, > > Paging or scrolling is purely an abstraction you create with the GUI > itself. If you load up 88 titles into memory and your screen display is > 40 lines then you have 3 "pages" in memory and you simply replace a > "page"

Re: [sqlite] [OT] How to implement paging

Hello Sam, Paging or scrolling is purely an abstraction you create with the GUI itself. If you load up 88 titles into memory and your screen display is 40 lines then you have 3 "pages" in memory and you simply replace a "page" each time they scroll or page up/down. You seem to be letting the

Re: [sqlite] [OT] How to implement paging

On Mon, May 25, 2009 at 2:43 PM, Tito Ciuro wrote: > Hi Sam, > > On May 25, 2009, at 10:58 AM, Sam Carleton wrote: > >> Example:  Following the logic of the ScrollingCursor page, lets assume >> a total result set of 88 titles.  If the lasttitle happens to be the >> 29th title, so

Re: [sqlite] [OT] How to implement paging

Hi Sam, On May 25, 2009, at 10:58 AM, Sam Carleton wrote: > Example: Following the logic of the ScrollingCursor page, lets assume > a total result set of 88 titles. If the lasttitle happens to be the > 29th title, so the set that is returned is 30 through 34, how do I > determine that this is

Re: [sqlite] [OT] How to implement paging

On Mon, May 25, 2009 at 2:31 PM, Simon Slavin wrote: > > On 25 May 2009, at 6:58pm, Sam Carleton wrote: > >> Example:  Following the logic of the ScrollingCursor page, lets assume >> a total result set of 88 titles.  If the lasttitle happens to be the >> 29th title,

Re: [sqlite] [OT] How to implement paging

On 25 May 2009, at 6:58pm, Sam Carleton wrote: > Example: Following the logic of the ScrollingCursor page, lets assume > a total result set of 88 titles. If the lasttitle happens to be the > 29th title, so the set that is returned is 30 through 34, how do I > determine that this is the 6th

[sqlite] [OT] How to implement paging

I want to thank the mailing list in general you all have been very helpful in my learning both SQLite and SQL in general. I am working on paging right now and simply don't know the SQL way of implementing it.  I have read through the SQLite page on scrolling cursor