Hacker News new | ask | show | jobs
by charlysisto 3179 days ago
I wrote nexter (https://github.com/charly/nexter) a few years ago without knowing I was applying the keyset principle (it's not pagination though but a next page library). It works well on a consistent data set but often falls short with Nulls, too many associations and whenever I aggregate stuff. Also it generates so many ANDs & ORs you do feel safer using Offset & Limit. I find it frustrating there's no easy solution provided by DBs for such a universal and simple need...
1 comments

Thanks. I've added it to the Hall of Fame: http://use-the-index-luke.com/no-offset#frameworks