starman@programming.dev to Programming@programming.devEnglish · edit-211 months agoWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netexternal-linkmessage-square19fedilinkarrow-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-211 months agomessage-square19fedilinkfile-text
If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
minus-squarecroccifixiolinkfedilinkarrow-up1·edit-211 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·11 months agoThe article proposes to add an incrementing number just for the sake of pagination.
deleted by creator
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.