Skip to content
Jan’s Blog

One of Feed Reader for WordPress’s nastiest bits …

By Jan’s photo Jan Boddez

One of Feed Reader for WordPress’s nastiest bits of code—well, there’s a few more—is the cursor paginator. Lots of raw SQL in there. I did look for a lightweight query builder library, but alas.

Replies

  1. Jan Boddez on

    Why cursor-based (and not “offset”) pagination? Because (1) marking entries as read will remove them from the current page and thus shift all “later” entries “to the left,” and (2) new entries being added in the background will cause similar shifts. Both events would result in items being missed or shown more than once as you browse back and forth.