STAGE 1: Have an idea to create a bsky client relying mostly on independent infrastructure... in PHP

STAGE 2: Discover that PHP is single-threaded which is why it starts timing out on requests probably

STAGE 3: Enter the exciting world of intricate asynchronous PHP calls

STAGE 4: Still needs more juice. Time to implement a caching layer in SQLite so don't need to make as many server calls

STAGE 5: Consider using an ORM, decide that's too much additional complexity, just write all the queries yourself

honestly the fact that php is single-threaded explains why wordpress is slow as hell once you start adding plugins.

i feel like this is the point where i'd like, start implementing the frontend in a javascript layer or something but also i'm doing this to test my abilities so that's right out. that'd be too easy.

also the sheer number of times i have just gotten a boolean condition backwards or something is embarrassing but i'm prone to it when i'm tired and i have a four-month-old so. i'm always tired. this is my secret (loop around to energy drink-based hyperfocus)

anyway i figured i could put a pretty long cache on posts (uneditable), a medium one on feed headers and PLC directory documents (change very rarely) and a short one on user info (change somewhat regularly and unpredictably) so now i'm in

STAGE 6: refreshing my code over and over to find the errors (you know, how you debug things)

anyway this has completely consumed me. i get really unhinged about projects especially when i create my own riddles three to figure out so that three days later i sit straight up in bed and go THAT'S IT. enrichment

(don't even ask about the fact that i'm spinning up my own constellation server so i can make low-latency calls. bonus post to come on how to install constellation)