Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

Hi Keith, 2015-01-09 2:02 GMT+03:00 Keith Medcalf : > > The table you are creating is called a keyset snapshot. That is how all > relational databases databases which support scrollable cursors implement > them (only navigable databases -- hierarchical or network or network > extended for exampl

Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

[sqlite] Scrolling Cursor implementation best practices >(pagination and arbitrary sorting) > >Hi Clemens, > >2015-01-08 13:34 GMT+03:00 Clemens Ladisch : > >> > >> http://stackoverflow.com/questions/21082956/sqlite-scrolling-cursor- >how-to-scroll-correctly-with-d

Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

Hi Clemens, 2015-01-08 13:34 GMT+03:00 Clemens Ladisch : > > > http://stackoverflow.com/questions/21082956/sqlite-scrolling-cursor-how-to-scroll-correctly-with-duplicate-names > > and yes, we can use title+rowid as lasttitle. But... it looks too complex > > to be 'best practice' pattern. > > Feel

Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

Max Vasilyev wrote: > http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor > and want to use WHERE, but what if 'title' is not unique? If the ORDER BY columns are not unique, you cannot know which rows to display on which page. You must be able to uniquely identify rows. > - This is considered h

[sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

Hi gents, I just want to show DataGrid with my table to a user with support of sorting and filtering by arbitrary column. As my table has ~200k records I'd like to implement data virtualization (paged access). Please, give me recommendations how to do pagination in the best way. The following is m