• 27 Posts
  • 407 Comments
Joined 3 years ago
cake
Cake day: June 12th, 2023

help-circle
















  • Had to solve the same problem few months ago, user provided content and so, user provided translations.
    We use postgres everywhere and we had to support 3 languages initially with one more eventually, so we decied to use json fields for anything that could be translated (which wasn’t too much). Mind you, this was basically a (temporarily permanent) prototype project but (fresh) postgres has a good support and operators for json so it worked alright.

    EDIT: I remembered that hstore might be a good alternative too, I think it was slightly less “heavy” and had better operators for the kind of access we needed





  • by jitter you mean ping lags/unstable ping?

    • remove all wireless connections between you and the internet if you can
    • in terminal, run ping against few different targets (to your gateway IP, to some random website/IP) and watch for packet drops, if you see them you might have a hardware problem (mb eth card/port, cable, router) or your ISP is having problems
    • check that your cable/router has correctly negotiated the wire speeds: ethtool <your-internet-interface-name:eth0> | grep -A1 Speed this will show you the speed (at least 100Mb/s) and Duplex: Full
    • maybe try changing cl_interp_ratio ?
    • run bufferbloat test
    • you sure noone is watching 4k corn while you are gaming ?