74
The Potential Pitfalls of Pagination
(jade.ellis.link)
Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!
Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.
Hope you enjoy the instance!
Rules
Follow the wormhole through a path of communities !webdev@programming.dev
Pretty useful article! I'm pretty sure I've seen data shifting happen a few times on Jerboa.
I wonder if uuid7 based pagination solves these issues. Precise enough that you don't overlap/over fetch data with time based pagination, while still being essentially time based so you have a consistent offset. Definitely important to limit the size if requests, though.
Probably not; I'd expect the places where you need something like UUIDv7 (large, eventually-consistent systems) to not be entirely suitable because you can have records added out of sequence. You'd have to add a received-at field - but in that case you may as well just use a standard incrementing ID as your primary key.