Is there even a human at any step or is this an agent running in the background with "go to HN front page" as its ultimate goal?
Also not totally clear to me (apologies if I missed it in the post) is where repositories live, I have a bsky account with my own domain, but I am not running anything to host a repo. Am I correct in assuming that bsky is hosting my repo, but I would have the option to self host or move it elsewhere and continue using bsky?
When it receives a post, it creates a row in the Post table. When it receives a comment, it creates a row in the Comment table, which has a column pointing to the Post it's replying to. Then, getting all comments under a post is easy SQL.
About your second question: yes, you're correct. What handle you use and where your data is hosted are completely separate matters.
https://hacks.mozilla.org/2018/10/calls-between-javascript-a...
I ended up going with Brave. Once you turn off their crummy VPN and crypto advert it's effectively just google chrome with a built in ad blocker.
I know there were arguments/concerns about the crypto thing, but I did a bit of research before picking a new browser (as should you) and once I realised it was a simple thing to turn off and never see again I was fine with it, it's all opensource as well so you can see how things work.
Of course it's just a chrome fork, so is still somewhat influenced by Googles decisions but that really wasn't the issue here, I just wanted to keep ublock origin and that's been the outcome.
I still have syncing and such all running between my desktop and mobile, I still have all the same extensions I've used for over a decade, so it's been relatively pain free to switch.
As much as Mozilla and Firefox can be criticized for both technical and non-technical reasons, at least I share the same core values. I don't seem to share any core value with Brave or its creator. Plus, yeah, still smells like Google :)
But if Evan Wallace didn't obsess over performance when building Figma, it wouldn't be what it is today. Sometimes, performance is a feature.