Pagination? No problem! SELECT ... LIMIT X, Y Right? Hah! Not quite! You see, your pagination logic is not stable; and that matters quite a bit in this ajaxy, client-appy, infinite-scrolly world. TL;DR? Don't paginate on row offset. Find a stable value to paginate on, like an item's date. Always deduplicate list items on the client side. Never trust your server to know exactly what the user is loo
![Pagination: You're (Probably) Doing It Wrong. (Example)](https://cdn-ak-scissors.b.st-hatena.com/image/square/d3ba0f51e8dafb432db4d5bb2dafe8e9def1c88b/height=288;version=1;width=512/https%3A%2F%2Fcoderwall-assets-0.s3.amazonaws.com%2Fuploads%2Fuser%2Favatar%2F53200%2FTransparent-Large.png)