• 2 Posts
  • 234 Comments
Joined 2 years ago
cake
Cake day: July 4th, 2023

help-circle








  • Okay but if that happens, musk is right that that’s a bit of a denormalization issue that mayne needs resolving.

    SSNs should be stored as strings without any hyphen or additional markup, nothing else.

    • Storing as a number can cause issues if you ever wanna support trailing zeros
    • any “styling” like hyphens should be handled by a consuming front end system, you want only the important data in the DB to maximize query times

    It’s more likely though it’s just a composite key…




  • They probably do use lots of NoSQL DBs too, which perform better for non relational “data lake” style architectures where you just wanna dump mountains of data as fast as possible into storage, to be perused later.

    When you have cases where you have very very high volume of data in, but very low need to query it (but some potential need, just very low), nosql DBs excel

    Stuff like census data where you just gotta legally store it for historical reasons, and very rarely some person will wanna query it for a study or something.

    Keep in mind when I talk about low need to query, the opposite high need us on the scale of like, "this db gets queried multiple times per minute’

    Stuff like… logins to a website, data that gets queried many times per minute or even second, then sometimes nosql DBs fall off.

    Depends what is queried.

    Super basic “lookup by ID” Stuff that operates as just a big ole KeyValuePair mapping ID -> Value? And thats all you gotta query?

    NoSql is still the right tool for the job.

    The moment any kind of JOIN enters the discussion though, chances are you actually wanna use sql now





  • So many people are extremely missing the point here

    Trump is purposefully threatening Canada to give his canadian conservative buddy Poilievre something to “fight” against, to make him look good

    “Wow Poilievre is standing up against Trump, I’m gonna vote for him!”

    That’s the game plan, in reality the two dipshits are best buds and can collude together to fuck over both countries extra hard, after conservatives get a majority over here.

    It’s a stunt to get conservatives in charge over here “against” Trump, which is so fucking stupid and yet it’s probably gonna work cuz so many people are gonna fall for it.

    I don’t think the liberal party has a good play against it, other than if our new liberal leader challenges Trump and musk to a boxing match and literally bears the shit out of them on live television

    I unironically think the Lincoln “I’ll fight you let’s go right now” leader who seriously fucks up Musk or Zuckerberg or any of those dipshits on live television would actually win by a landslide here

    It’s fuckin stupid but that’s what works apparently…



  • For those of us using the tools, actively, it doesn’t seem to be a bubble.

    For a lot of us it’s already showing tangible measurable productivity increases, primarily on boring stuff normally we’d hate doing.

    As an example, I use it often to help with documenting my code, it’s really good at summarizing what my code does abd making clear, legible, professional documentation for all my code.

    That sorta stuff would normally take me hours and hours to do, now it takes about 1.

    I still proof read it, but a lot of my typing and formatting and humming and hawwing is gone.

    There’s a lotta shit like that out there getting streamlined more and more every month that goes by.

    I think it’s maybe 50/50 bubble and actual value. Lots of garbage “products” vaporware out there by people on the bandwagon.

    But also a lot of the tools truly are useful to folks.


  • I have to have Windows 11 now for security reasons.

    Can… you not upgrade your current work machine to win11?

    Just tell them that you’ll send them back the laptop for the upgrade if you have to, or IT can do it remotely, but you dont have another PC to use, that’s why you had one issued.

    They only way I would use my personal PC is if I am VPN+RDPing into a work machine, and that’s it. I’ve done that many times before, as that’s secure and doesn’t have any work resources on your oc itself, you’re just remotely connecting to your actual work PC over a secure vpn.

    That’s the only scenario that I use my personal PC for work.


  • Fundamentally good CEOs expect a wage based on the market.

    There’s tonnes of high paying positions so, no, non profits truly will struggle to find an actually good CEO if they dont offer a competitive wage.

    It’s not their fault, it’s the lack of regulation on all the for-profits and the fact they can funnel so much money up to CEOs unchecked.

    If for-profits had regulatory checks that made them do that less, then non-profits wouldn’t have to compete with nearly as insanely high wages.

    IE if there was a law that CEOs couldn’t be paid more than 10x their lowest paid worker, this problem would be a lot less insane.