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

help-circle





  • I haven’t said anything on the subject before, because I don’t care very much, but I don’t know what the alternative is supposed to be. It’s not like someone who is that famous can walk into a public airplane without putting her own safety at risk and causing trouble for other passengers.

    It’s also well known that conservatives really hate her because she told her fans to vote and these memes are part of their effort to discredit her. Whether the point has any merit or not, it’s obvious who started the trend and who it’s helping.




  • 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.


  • old webpages (like from the 2000s) are fast and snappy. new webpages take much longer to load.

    This part is true, especially on phones, but those old webpages were not fast at all when they were first published.

    I remember trying to watch videos on dialup Internet. I’d make it start buffering and then go do something else for half an hour before coming back to watch the video. I also remember avoiding certain websites even on DSL because they had 1 or 2 whole megabytes of JavaScript and it took forever to load.

    Increases in bandwidth and processing power has made those old websites seem a lot more performant than they were at the time.

    Today we can put a lot more stuff on our websites than we used to, which makes things slower, but we’re also much more aware of major performance issues. Google uses it as a factor in their ranking algorithm, and offers a pretty intelligent tool to help developers figure out where to optimize their websites, so it’s essential for most companies to optimize for that. Giant companies like Amazon and Facebook can ignore it because they’ll always be on top, but the rest of us are getting really excited about new frameworks like solid and qwik that will make it a lot easier to optimize our sites.





  • 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.


  • Close encounters of the racist kind is a good read. Here’s the most relevant part:

    Consider the H2 series “In Search of Aliens,” which, before its demise, promoted the work of Jan Udo Holey, a German writer whose antisemitic books have been banned across Europe. (Holey’s pen name, Jan Van Helsig, is a blunt Dracula reference, i.e. Jews are bloodsuckers.) The History Channel’s long-running series “Ancient Aliens,” meanwhile, features David Childress, whose books cite and build on the work of James Churchward, who promoted an ancient empire called the “lost continent of Mu,” whose “dominant race” was an “exceedingly handsome people, with clear white or olive skin.”

    The history channel is entry level nazi propaganda.