Sqkon/com.mercury.sqkon.db/KeyValueStorage/selectKeysetPagingSource

selectKeysetPagingSource

fun selectKeysetPagingSource(pageSize: Int, where: Where<T>? = null, orderBy: List<OrderBy<T>> = emptyList(), expiresAfter: ERROR CLASS: Symbol not found for Instant?? = null): ERROR CLASS: Symbol not found for PagingSource<kotlin/String, T>(source)

Create a PagingSource that pages through results using keyset-based pagination. Unlike selectPagingSource, this avoids the O(n) cost of SQL OFFSET on large datasets by using pre-calculated page boundary keys.

Page boundaries are computed once per PagingSource lifecycle. When data changes, the PagingSource is invalidated and a new one is created with fresh boundaries.

Note: PagingSource.jumpingSupported is false for keyset paging — pages must be loaded sequentially from the start or a refresh key.

Parameters

pageSize

The number of items per page, used to compute stable page boundaries. Should match the PagingConfig.pageSize used with the Pager.

expiresAfter

null ignores expiresAt, will not return any row which has expired set and is before expiresAfter. This is normally Clock.System.now.