I’ve started building an AS-based POC as a replacement for Cassandra, but stuck with pagination (user posts with an infinite scroll). To be fair - there are a lot of places already discussing pagination (people asking either for offset/limit or cursor implementation), however all answers are actually workarounds with their disadvantages, rather than pointers to “official” function/implementation, for example - using LLIST.
Please advise, is it just my misunderstanding of AS’s goal and its just not meant to be used in pagination scenarios working more like an advanced version of redis, or there is actually a correct/native/official way to provide pagination like offset,limit of MySQL or pagestate in Cassandra (maybe using UDFs)? If latter, could you please provide a link to documentation (ideally, of the Go driver) describing the approach?
Thank you! D.