

2·
3 days agoI 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
same here more or less, at home nothing is open anymore, everything goes through tailscale and a raspberry pi that also does the wake on lan for the big pc when I need it. the only thing exposed is a hetzner vps with a small browser game, and there I keep it boring, ufw with just 80 and 443 (and rtmp for a stream relay), caddy in front, the node app and postgres only reachable from inside the box. I guess that’s the trade off that works for me, whatever strangers need to reach lives on one machine I watch closely, the rest stays behind the vpn