valtia

@valtia@lemmy.world

• ⁨Comment⁩ on ⁨From what I've seen, public transit is either expensive and terrible or cheap and good.⁩ ⁨⁨6⁩ ⁨days⁩ ago⁩:

  The Shinkansen network in Japan was infamously extremely expensive and during its construction, many Japanese hated it and doubted it would ever amount to much. Today, it is held up as the best public transit system ever created.

  Here in Seattle, the Link Light Rail system is also extremely expensive, though this is due to many factors, notably the fact that between the time the project got started and initially set its funding goals, the Covid pandemic happened and massive inflation, both in currency and in raw materials. However, the lines that are finished are extremely nice. The Link system is shaping up to be some of the best in the entire US, and the biggest and most important section hasn’t even opened yet: the world’s first rail line to travel across a floating bridge. Once the bridge section is complete, it will connect the two separate systems on the west and east sides of Lake Washington into one system and allow fast, efficient transit from the east side into downtown Seattle.

  Anyway, my point is that just because a system is expensive, doesn’t mean it’s bad. I think you’re just furthering car-centric propaganda and reinforcing the belief that public transit is expensive and therefore bad

• ⁨Comment⁩ on ⁨Trump floats dropping Spain from NATO alliance⁩ ⁨⁨4⁩ ⁨weeks⁩ ago⁩:

  5% but 3% can be fulfilled with infrastructure spending like roads and bridges that can support tanks

• ⁨Comment⁩ on ⁨proof of wormholes⁩ ⁨⁨1⁩ ⁨month⁩ ago⁩:

  Drinking alcohol doesn’t give adults birth defects either, but drinking alcohol while pregnant causes birth defects in the child 🤯

• ⁨Comment⁩ on ⁨"Tea cup" app - user database leaked today (incl. drivers license & IDs). Daily reminder not to give your ID to online services [THEY DO NOT PROTECT YOUR INFORMATION]⁩ ⁨⁨3⁩ ⁨months⁩ ago⁩:

  Alright, but none of that was really relevant to this comment. Why are you soapboxing on it?

• ⁨Comment⁩ on ⁨"Tea cup" app - user database leaked today (incl. drivers license & IDs). Daily reminder not to give your ID to online services [THEY DO NOT PROTECT YOUR INFORMATION]⁩ ⁨⁨3⁩ ⁨months⁩ ago⁩:

  As usual on Lemmy, the answer is just for women to shut up and listen to what the men want

• ⁨Comment⁩ on ⁨"Tea cup" app - user database leaked today (incl. drivers license & IDs). Daily reminder not to give your ID to online services [THEY DO NOT PROTECT YOUR INFORMATION]⁩ ⁨⁨3⁩ ⁨months⁩ ago⁩:

  Yes, trying to warn other women about a man you dated who abused you or gave off weird vibes is definitely the same as getting your nudes or porn video of yourself leaked against your will onto the public internet for everyone to see

• ⁨Comment⁩ on ⁨"Tea cup" app - user database leaked today (incl. drivers license & IDs). Daily reminder not to give your ID to online services [THEY DO NOT PROTECT YOUR INFORMATION]⁩ ⁨⁨3⁩ ⁨months⁩ ago⁩:

  The app ostensibly required ID uploads to verify that you were a woman signing up, men were not allowed to join for obvious reasons

• ⁨Comment⁩ on ⁨Are conservatives mad about trans people or they just mad they get walk around out of the closet while they have to leave the white sheets at home?⁩ ⁨⁨8⁩ ⁨months⁩ ago⁩:

  You must not hang out around trans people IRL then. Whenever I’m out with my friends, someone usually has to make a comment about or to one of my trans friends, just to be mean I guess? I don’t even understand why people feel so happy making her upset

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨8⁩ ⁨months⁩ ago⁩:

  in this case you would just overwrite the existing row, you wouldn’t use de-duplication because it would do the opposite of what you wanted in that case.

  … That’s what I said, you’d just update the row, i.e. replace the existing data, i.e. overwrite what’s already there

  Definitionally, the actual identity of the person MUST be unique, otherwise you’re going to somehow return two rows, when you call one, which is functionally impossible given how a DB is designed.

  … I don’t think you understand how modern databases are designed

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨8⁩ ⁨months⁩ ago⁩:

  i genuinely cannot think of a single instance where you would want to delete one entry, and replace it with a reference to another

  Well, there’s not always a benefit to keeping historical data. Sometimes you only want the most up-to-date information in a particular table or database, so you’d just update the row (replace). It depends on the use case of a given table.

  what elon is implying here (remove “duplicate” entries, however that’s supposed to work)

  Elon believes that each row in a table should be unique based on the SSN only, so a given SSN should appear only once with the person’s name and details on it. Yes, it’s an extremely dumb idea, but he’s a famously stupid person.

• ⁨Comment⁩ on ⁨How does this pic show that Elon Musk doesnt know SQL?⁩ ⁨⁨8⁩ ⁨months⁩ ago⁩:

  There can be duplicate SSNs due to name changes of an individual, that’s the easiest answer. In general, it’s common to just add a new record in cases where a person’s information changes so you can retain the old record(s) and thus have a history for a person. That’s how the SSA is able to figure out if a person changed their gender, they just look up that information using the same SSN and see if the gender in the new application is different from the old data.

• ⁨Comment⁩ on ⁨Looks legit, but can it actually be a real thing?⁩ ⁨⁨8⁩ ⁨months⁩ ago⁩:

  Conservatives would just blame it on DEI and it somehow being funded by USAID