starman@programming.dev to Programming@programming.devEnglish · edit-210 months agoWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netexternal-linkmessage-square20fedilinkarrow-up117arrow-down117file-text
arrow-up10arrow-down1external-linkWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netstarman@programming.dev to Programming@programming.devEnglish · edit-210 months agomessage-square20fedilinkfile-text
If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
minus-squareLalSalaamComradelinkfedilinkarrow-up1·edit-210 months agoThis technique will not work for databases than uses uuid instead of integer, right?
minus-squarecroccifixiolinkfedilinkarrow-up1·edit-210 months agoIt will if you’re using UUID v7 which is time-ordered. There are also alternative implementations such as ULID and KSUID that are time-ordered.
minus-squarejochemlinkfedilinkarrow-up1·10 months agoThe article proposes to add an incrementing number just for the sake of pagination.
This technique will not work for databases than uses uuid instead of integer, right?
It will if you’re using UUID v7 which is time-ordered. There are also alternative implementations such as ULID and KSUID that are time-ordered.
The article proposes to add an incrementing number just for the sake of pagination.