Also http://use-the-index-luke.com/sql/partial-results/fetch-next... for the actual keyset paging (aka the seek method) technique. Which gives a better explanation than the OP's article IMO.

But how would you build a paginator?

How would you give a link to page 9 when you're on page 1?

You can't: On slide 43 you can also see that keyset pagination has some limitations: most notably that you cannot directly navigate to arbitrary pages. However, this is not a problem when using infinite scrolling. Showing page number to click on is a poor navigation interface anyway—IMHO.

As someone who often skips a few pages when navigating such interfaces, I say "thanks, but no thanks".