Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination

starman@programming.dev to Programming@programming.dev – -2 points –
Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination
ivopereira.net

If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it

17

You are viewing a single comment

Is there a way I can access this article without making an account?

I'm not going to make an account.

Sorry for inconvenience, I updated the link

Oh thanks mate 👍

Interesting article but I kinda fail to see how you'd go if your paginating through sorted rows - you'd have to have an id in the sequence of your sort order?