• 0 Posts
  • 12 Comments
Joined 1 year ago
cake
Cake day: June 18th, 2023

help-circle





  • It’s probably not, but let’s say that replying to a comment deep in a thread required an update to every parent comment (very unlikely), if the attackers knows this they could trigger that very expensive SQL query many times very quickly by letting some bots comment many times to create a very deep comment chain and force the server to make the queries. If the server didn’t, it would either mean that no one could comment in that way it would have to know what is and isn’t an attack which isn’t easy.




  • It does not. It in large part scales with the amount of content the local and federated communities. So because many users will subscribe to many of the same communities, more users will add less extra cost aftter a point. This is a bit simplified though as it also scales with users but to a lesser degree from my understanding.

    Disclaimer: I’m not hosting myself just to be clear but this is what I have gathered from answers to similar questions as well as my own experience as a software dev.




  • Ignorance and overconfidence in one self can lead to decisions that puts one in danger. If he didn’t understand the risks, overestimeted his control over the situation (as very rich people are prone to do) or simply surrounded himself with too many yes-men, then hi might not have thought he put himself in as much danger as he did. On the other hand he could also just see himself as an explorer and seeking rhe thrill as many of the dead bodies on Everest once did.

    I’m sure there are many reasons he could have gone into that sub despite having been told the risk. I of course can’t know for sure, but it does seem more likely in light of his comment than without it.