The disappearing customer: How unstable sorting breaks pagination
I have recently discovered a strange issue where a record in my database mysteriously disappears from a paginated API endpoint. And in fact, this is an issue that could happen to you as well, if your sorting is unstable. But let’s start from the beginning. The Starting Point In my application, I have an endpoint that returns all customers, sorted by customer group. So each customer is assigned to...