• 0 Posts
  • 63 Comments
Joined 1 year ago
cake
Cake day: June 17th, 2023

help-circle







  • IMO it should even be hashed on the client side before being sent so that it doesn’t show up as plaintext in any http requests or logs. Then salted and hashed again server side before being stored (or checked for login).

    But if someone got that hashed version they could hack the client to have client side hashing code just send that hashed value to the server. You’d want to have the server to send a rotating token of some sort to use for encrypting the password on the client and then validate it on the server side that it was encrypted with the same token the server sent.

    Seems complicated to me… https is probably has good enough encryption, so eh, whatever.


  • Having a lot of joins can be expensive and non-performant.

    Only if you don’t know how to do indexing properly. Normalized data is more performant (less duplication of data, less memory and bandwidth is being used) if you know how to index.

    It may have been true decades ago that denormalized tables were more performant, I don’t know. But today it’s far more common that the phrase “denormalized tables are more performant” is something that’s said by someone that sucks at indexing and/or is just being lazy.

    But I do put JSON into tables sometimes when the data is going to be very inconsistent between different items and there’s no need to index any of the values in there. Like if different vendors provide different kinds of information about their products, I need to store it somewhere, so just serialize it and put it in there to be read by a program that has abstraction layers to deal with it. It’s never going to perform well if I do a query on it, but if all that’s needed is to display details on one item at a time, it’s fine.





  • SpaceCowboy@lemmy.catoProgrammer Humor@lemmy.mlWorst is UTC vs GMT
    link
    fedilink
    arrow-up
    6
    arrow-down
    1
    ·
    4 months ago

    Yeah it’s just being angry about the fact that the Earth is rotating ball. Wanting to abolish timezones is different from Flat Earth only be degrees.

    Sure the “what time is it there?” question goes away, but it’s replaced by “what are your business hours?”

    Ultimately it will be daytime in one part of the world while it’s night in another part of the world. That will always cause problems.


  • This is actually the best approach.

    Obviously they are getting timezone information otherwise the app could only display whatever time the user entered in.

    If you want to sort things by the actual time, it’s simple and performant if all of the times are in the same timezone, and UTC would be the standard one to use. Pushing the timezone calculations to the client makes sense because the UTC time is correct, it’s just a matter of displaying it in a user friendly way, ie. show the time in the user’s timezone.


  • I’m not the guy you replied to, but MS fonts are kinda free to download. Not free enough they can just put them into a package but there’s a defined method for downloading them. Most distros have a package that will automatically do this. On Debian it’s ttf-mscorefonts-installer which will download the fonts and install them when it gets to the configuration part of the package install. You can probably search for a similar package for your distro.


  • Apparently I’m Neutral Evil. But I consider myself to be Chaotic Neutral.

    I’ll fix the problem only when it’s actually a computer problem and when you can explain what the problem properly. I don’t care if it’s a ticket or an email. Though I might not get to the email today and tomorrow I might forget about it, so you might want to put a ticket in that’ll stay the until it’s closed. But the ticket system sucks, so I might not log into it and see your ticket for a few days. If you send an email, I might do it right away, but you might have to remind me about it in a few days because I might’ve forgotten about it.

    I don’t care about your job title. If you VP of whatever the fuck and think you’re important or if you were hired yesterday to an entry level position, you’re all users to me. But the issues aren’t fixed based on the order they come in, it’s based on how much effort you put into describing the problem. If you think you’re too important to describe the issue properly, you’re low priority. If you want a meeting to describe the issue verbally, oh you better believe you’re low priority, I’m not your fucking secretary that’s going to take down your dictation. You got a keyboard in front of you, use it. I might eventually get around to asking you for more details about the problem, but only after I’ve fixed all of the problems reported by people that made an effort. Your priority is based on your effort.

    Ok so maybe I’m Lawful Evil? But everyone thinks I’m Chaotic Evil because they don’t understand why some people get stuff done right away while they have to wait.



  • Debian is like my wife, I’m always faithful to her!

    Ok, can you keep a secret? I have cheated on her a few times. I tried redhat before I met Debian, but didn’t get very far because of circular dependencies (it was the 90s and package management was new). I never used another Linux and wanted to experiment a little!

    I compiled Linux From Scratch, but it was too high maintenance. I tried Gentoo, but it’s not something I’d put on a friend’s computer, ya know what I mean? And yeah, I admit it, I had a fling with Debian’s little sister, Ubuntu. But it was basically like Debian, but a little more sexy but also a little more flakey.

    But in the end, I always go back to Debian. Solid, dependable, and low maintenance. Just upgraded to bookworm this weekend (because I’m always behind on dist upgrades LOL). Updated the apt sources ran recommended the apt commands with no issues. Only noticeable difference is the grub and login screens are a different shade of blue.