starman@programming.dev to Programming@programming.devEnglish · edit-27 months agoWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netexternal-linkmessage-square17fedilinkarrow-up115arrow-down117file-text
arrow-up1-2arrow-down1external-linkWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netstarman@programming.dev to Programming@programming.devEnglish · edit-27 months agomessage-square17fedilinkfile-text
If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
minus-squareYodaDaCoda@sh.itjust.workslinkfedilinkEnglisharrow-up2·7 months agoIs there a way I can access this article without making an account? I’m not going to make an account.
minus-squarestarman@programming.devOPlinkfedilinkEnglisharrow-up4·7 months agoSorry for inconvenience, I updated the link
minus-squareYodaDaCoda@sh.itjust.workslinkfedilinkEnglisharrow-up2·7 months agoOh 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?
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?