

i run a small browser game on a hetzner vps and for me the bots were never a load problem, it was the stats. the game shows how many people are online and every crawler that opened the live stream counted as a new player, in early october it was 28 of 61 stream opens. then a headless chromium on residential proxies, different ip every time, made 40 fake players in two days. what caught it was the Sec-CH-UA header, it said chromium 146 while the user agent said chrome 120, real browsers don’t mismatch like that. i don’t block them now, they just stop counting as people, which is kind of depressing too i guess
I run postgres on a small hetzner vps for a browser game and right now it’s just ssh + psql, read only and with a statement timeout so I can’t break anything by accident. the column masking is the part that would make me try it, I look at prod with player data in it and honestly I’d rather not see some columns at all. one thing I’d want to know, if I close the tab in the middle of a long query does it get cancelled on the server? I had a script that got killed and its query kept running on prod for a while lol