Live Queries - SurrealTools/Documentation GitHub Wiki

Pagination

You can use select for that. Live queries could hypothetically be paginated, but then they aren't live. If you want live updates on paginated data, then you can do a live query on the IDs.

let vals = select * from table WHERE.. START.. LIMIT...
let ids = vals.id
driver.query("LIVE SELECT * from $ids")

You can access the range of records for the live query then, LIVE SELECT * FROM table:start..table:end. That is really interesting, but it does depend on your ordering being the primary index. You could hypothetically access the secondary indexes directly, but... I'm not sure if I should be recommending that 😂 It is a tenant of this engine to actually give people access to the things they want to do.