logo

Why pagination sometimes has overlapping pages

A deeper look inside the database

Joel Clermont
Joel Clermont
2026-08-21

This is a weird issue that you might never notice unless you're really paying attention. It involves database sorting logic on duplicate values and how that can interact in unexpected ways with pagination logic.

In this video, I walk through a demo example and show the fix, along with a simple rule to keep in mind to know when this fix is necessary.

Watch Now (4 min)

And after watching, don't forget to subscribe to our YouTube channel, so you don't miss future videos.

Here to help,

Joel

P.S. Bugs like this hide in code that looks completely fine. Our code review digs into exactly these kinds of subtle issues before your users find them.

Toss a coin in the jar if you found this helpful.
Want a tip like this in your inbox every weekday? Sign up below 👇🏼
email
No spam. Only real-world advice.