[sqlite] Magic number in sqlite source code

2015-12-31 Thread Max Vasilyev
Hello, Richard! Probably PTR_SZ or PAGE_PTR_SZ would be good? I feel confusing about OVFL_. Why size of the pointer to the first overflow page could be different from size of another pointers? Sorry, I'm far from the code and should not discourse. Just have an idea that name should be as common

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

2015-01-09 Thread Max Vasilyev
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

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

2015-01-08 Thread Max Vasilyev
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

Re: [sqlite] Index rownum

2015-01-07 Thread Max Vasilyev
. And firebird feels slow. So SQLite wins! Thanks, Max 2015-01-08 3:23 GMT+03:00 Richard Hipp <d...@sqlite.org>: > On 1/7/15, Max Vasilyev <maxrea...@gmail.com> wrote: > > Hi guys, > > Is it possible to get key number from the index? > > For example let's conside

[sqlite] Index rownum

2015-01-07 Thread Max Vasilyev
Hi guys, Is it possible to get key number from the index? For example let's consider Figure 4: An Index On The Fruit Column from here https://www.sqlite.org/queryplanner.html index_rownum, fruit, rowid 1 Apple 2 2 Grape 5 3 Lemon 18 4 Orange 1 5 Orange 23 ... Is it possible to add rownum column

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

2015-01-07 Thread Max Vasilyev
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