Well, pagination would be kind of the dumb way to do that. Smarter would be allowing users to query using a timestamp and then simply jump back to 1st of July 2007 or whatever it is you are looking at. Google photos does this pretty nicely. Using timestamps is also a smarter way to implement pagination if you do actually need it: select * where timestamp < x order by timestamp desc limit 10; Pretty cheap query to run if you have an index on the timestamp and you can just grab the next timestamp from the last result.

I've been doing search stuff for a while and this kind of UX requirement always pops up when you are dealing with junior designers or POs. They're thinking "hmm search" lets have some paging and just blindly copy a broken UX.

HN solved it nicely by just having a load more. I might hit that a few times but rarely more than a couple of times. One weird thing with that is that new articles often get added in between clicks in which case articles from the previous page reappear on the next page.