Pagination

[JumpingCrazyBeaver2319]

Is there a recommended approach for pagination, or is it not supported by this db?

[SalomonBrys]

A Cursor can stay opened as long as you'd like, so you can keep it open and manage paging with it.

Another way is to use transientSeekKey and seekTo, which is not documented (and it should be, this is a mistake).

transientSeekKey returns a Memory that's only valid until the cursor moves, so you need to copy its bytes.
seekTo takes a Memory and moves the cursor to the corresponding position.

val sk: ByteArray = cursor.transientSeekKey().getBytes()

/*... You can save this ByteArray in instanceState, for example */

cursor.seekTo(sk.asMemory())

I'll leave this issue open until this behaviour is properly documented