valtia

iirc it's also only helpful if you're already deficient in vitamin A, which the majority of Americans aren't. It's the same thing with Ivermectin: it looked like it was helpful for covid in aggregate, but only in developing countries where parasites are common. So, treating someone's parasites with a horse dewormer made the person healthier overall and meant their immune system could commit more resources to fighting covid, but someone without parasites (meaning the majority of Americans) would get absolutely no benefit.

Firstly, the article is not at all implying that Pence was impaired by her prescription medication, but I agree the part about her prescription medication should not have been mentioned at all since she was sober and unaffected by anything.

Secondly, it's a mistake to believe the officer's arrest report in the first place. There is no evidence that she was "crossing over the lanes several times", which is also why her case was dropped. American police routinely lie in their official arrest reports, it might actually even be policy in many places.

What do you mean "next admin"? This is it

Here are some of the real, actual and totally-not-biased questions asked in this survey. There are no alternatives to these questions, these are the only ones asked about particular policy positions:

DJT08 Do you support or oppose each of these policies:

• Deporting immigrants who are here illegally and have committed crimes
• Undertaking a full—scale effort to find and eliminate fraud and waste in government expenditures
• Closing the border with added security and policies that discourage illegal crossings
• Banning men who have undergone operations and hormones to become women from girls sports
• Declaring that there are only two genders male and female in all government forms and programs
• Eliminating all preferences by race in the hiring and awarding of government contracts
• Freezing and re—evaluating all foreign aid expenditures and the department that handled them
• Placing reciprocal tariffs on countries that have tariffs on US goods

https://harvardharrispoll.com/wp-content/uploads/2025/02/Feb2025_HHP_Crosstabs.pdf

This is quite possibly the worst-designed and loaded poll I have ever seen

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

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

Presumably, they also fired the staff who know how to look that information up

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.

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 (look up Slowly Changing Dimensions (SCD)). 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.

Another accusation Elon made was that payments are going to people missing SSNs. The best explanation I have for that is that various state departments have their own on-premise databases and their own structure and design that do not necessarily mirror the federal master database. There are likely some databases where the SSN field is setup to accept strings only, since in real life, your SSN on your card actually has dashes, those dashes make the number into a string. If the SSN is stored as a string in a state database, then when it's brought over to the federal database (assuming the federal db is using a number field instead of text), there can be some data loss, resulting in a NULL.

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

It's especially funny since HIV now affects more straight people than gay people