News for hackers. Stuff that matters.
Re:How to Design Better APIs by akvadrako on Saturday March 12, 2022 @02:06AM (#30649562)
You should use stable page boundaries instead of cursors. If you are returning results by timestamps, the page boundary should be the timestamp and secondary ordering keys of the last row returned.

Cursors take too many server resources and require client affinity.

Re:How to Design Better APIs by JimDabell on Saturday March 12, 2022 @02:11AM (#30649576)
You’re describing cursor-based pagination. It’s got nothing to do with the SQL concept of cursors.