• 0 Posts
  • 26 Comments
Joined 11 months ago
cake
Cake day: August 16th, 2023

help-circle
  • icydefiance@lemm.eetomemes@lemmy.worldWebp Discourse
    link
    fedilink
    arrow-up
    6
    ·
    edit-2
    7 days ago

    They do, most of the time. For example if you upload an heic file from an iPhone to a file input on a website that doesn’t accept heic files, it’ll upload a jpeg.

    Apple can’t see or control all the different ways of transferring files, though, so in practice it still causes problems sometimes.

    The strange thing is that some Android phones also save photos as heic files and make no attempt to convert them, so I still had to add logic to my websites to convert them myself.









  • If your connection is stable, the latency will more or less be the same, but TCP will consume more bandwidth because of acknowledgement packets, making it harder to keep your connection stable.

    On an unstable connection, TCP latency will skyrocket as it resends packets, while UDP will just drop those packets unless the game engine has its own way of resending them. Most engines have that, but they only do it for data that is marked as “important”. For example using an item is important, but the position of your character probably isn’t, because it’ll be updated on the next tick anyway.





  • Postgres normalizes table and field names to lowercase, unless you put them in quotes. It’s also case sensitive.

    That means if you use quotes and capital letters when creating the table, then it’s impossible to refer to that table without using quotes.

    It also means if you rename the table later to be all lowercase, then all your existing code will break.

    Still a much better database than MySQL though.