What is the best practice for offset pagination using FaunaDB?

[ptpaterson]

See also this previous Topic. Particularly since you include “offset” in the title.

Recommended way of doing a page offset?

This is easily translatable into fauna (assuming $LIMIT < 100k): Drop(Paginate(....., {size: $LIMIT}), $OFFSET). “But, Ben!” I hear you exclaim: “isn’t that really inefficient?”. Yes it is, and so is the SQL. What you probably want to do is keyset pagination, which is efficient, and also representable in fauna using the Range function, or using the before and after cursors.

I was helpful for me to be mindful of what Ben here identifies as keyset pagination, as opposed to offset pagination.

The linked article concludes that you should be really, REALLY sure that you need

• Exact page number
• High page numbers
• The last page number
• The total number of rows

Because most applications don’t, and by avoiding those things you can improve both performance (cost!) and user experience at the same time.