First it was Amazon region-wide service issues. Now it's Cloudflare having issues.
https://www.cloudflarestatus.com/

Fuck sake man.

I was wondering why my db changes kept crashing my backend as I was testing locally against the testing db. Turns out I modified the prod db without realizing. Good thing it wasn't about deleting things or anything critical. 🙃

necessity the mother of invention

or boredom?

Offset pagination is one of the biggest collective failures in software engineering.

Who wakes up one morning yearning to visit page 7218 of 100000 in the dataset?

No one, right? Because that’s not how it’s supposed to work. That’s what the search feature is for. Not that developers don’t fuck it up too, but that’s the not the point of this rant.

The truth is, most developers are lazy and don’t want to properly handle stuff. It’s even made worse by ORMs, where some dumb ass will use Django to make a shitty API without a care in the world about the underlying database.
Then after a few months of ever increasing data, they start experiencing very slow queries and response times.

Gee, I wonder what it could be! Could it be that the DB is having to go through hundreds of rows just to return the 100001st row? 

Designers also defaulting to Page 1 of 2322222 UI like the NPCs they are, is a big problem.

Pagination UI, if not done right, is a performance nightmare masquerading as a feature, solving a user problem that doesn't exist.

Fuck whoever came up with this bullshit.

I’ve had 3 side gigs where my task was to speed up the system and it always ended up being an issue with pagination. Once worked on a project where the dashboard toook 8 minutes. Yes, you read that right. 8 minutes to load. The company had accepted it as normal until a new manager joined and said, fuck that. Brough me onboard to unfuck the mess. No issue with Django devs, but bro, learn how to deal with databases properly for fuck's sake.

Before you came at me with, “well, what if I want to give users the ability to jump between pages”. Bro, that’s what search is for! If search is not allowing users to access the exact data they want, then it’s broken.
Pages are not deterministic anyway, because page 4 today won’t have the same data tomorrow.

I just fucking hate badly implementation pagination. Fucks up my day.