codexarcanum

joined 3 months ago
[–] [email protected] 33 points 1 month ago (2 children)

At least the names are extremely self-documenting. Some of those German variable names are long enough they might even be self-aware!

[–] [email protected] 5 points 1 month ago* (last edited 1 month ago)

~~I think you can tag the community like a person in a Mastodon post and it shows on the community? Like @[email protected] but from Masto.~~

Nope! Doesn't seem to work. Could be that my mastodon instance doesn't federate to Lemmy.world though. If you search that "user" in masto you can follow them to see posts in this community, but seemingly not make them.

[–] [email protected] 8 points 1 month ago

Words also just rotate around in popularity like any other fad. Remember synergy? Paradigm shifts? Thinking outside the box?

Academia isn't immune to memes, far from it. In the semi-contained world of higher education, trends in words and phrases are even more pronounced and likely to spread.

If this is evidence of LLM usage, it could easily be the machines reflecting back trends. These things pick up on subtle cues in your prompts to match tone with you as well so I wouldn't rule out human influence either in prompts or the RLHF process.

[–] [email protected] 31 points 1 month ago (3 children)

I bought the "Doom x John Brown" shirt from their site last year and, as a lifelong Doom fan and anti-confederate, really savor wearing it when I go out.

[–] [email protected] 28 points 1 month ago

Imagine being a director at this company. One of your employees brings you a report showing that your most active users, who are the backbone of your business, have a huge overlap with rape reports. This will destroy the company, and you know they'll fire you for bringing it up and suppress it anyway. So you just.... forget... to bring it up at the next quarterly. You used to work at Uber, and before that covering up how gambling and gaming companies float on a raft made of addicts, so this is well practiced blindness.

[–] [email protected] 4 points 1 month ago* (last edited 1 month ago) (4 children)

There are aspects that could be better, sure. I think communities should be like sets of posts, subject to unions, conjuctions, and other set operations. Then you wouldnt have the issue of 5 versions of c/memes, they could be virtually joined into one memes community at the user level (and the user can filter out instances, communities, and users they don't like of course). Moderation could be decoupled from communities and made a broader service that users choose to interact with, agreeing to a level of moderation comfortable for their experience.

But also, put me in the group that thinks lemmy should stay small. Corpo social has convinced us that a single big room with every idiot and literally their mother screaming into it is how the internet should be and it isn't. We can go back to smaller, focused online communities that don't openly invite everyone to come in and fight.

Centralization tendencies are all rooted in power and control. We need to fragment more.

[–] [email protected] 8 points 1 month ago

I'm being sarcastic but not by much. Nordic countries do have much better digital id systems and the EU overall looks to be following their model.

https://www.mitid.dk/en-gb/get-started-with-mitid/

https://www.openbankingexcellence.org/blog/eid-and-the-eu-digital-identity-frameworka-scandinavian-perspective/

[–] [email protected] 13 points 1 month ago

He's complaining that a number isn't unique and is being poorly used, but the number isn't supposed to be unique and he's complaining that it's not being used in a way that experts are specifically warned not to use it in.

But on a second, stupider layer, this is the system those numbers originate from. So however they use them is how they're supposed to be used.

But then, back above that first stupid layer, on an even more basic and surface level degree of stupid, the government definitely uses SQL databases. It uses just... so many of them.

[–] [email protected] 25 points 1 month ago (5 children)

It's wild too. I've been in the hospital a lot lately and in addition to a bar-code wristband, every healthcare worker, before doing anything with me (the patient) will ask my full name and either birthday or address and then double-check it against the wrist band. This is to make sure, at every step, that they didn't accidentally swap in some other patient with the same name. (Not so uncommon, lots of men have their father's name.)

Meanwhile in like Iceland, everyone gets assigned a personal GPG key at birth so you can just present you public cert as identification, not to mention send private messages and secure your state-assigned crypto-wallet. Not saying such a system is without flaw but it seems a lot better than what we're doing!

[–] [email protected] 12 points 1 month ago

This is a good summary. I had to go pull up wikipedia on it since I roughly knew that social security was a national insurance/pension kind of system but am actually hazy on details.

The major issue with it as id (aside from DBA's gripes about it) is that credit agencies and banks started to rely on it for credit scores and loans. You see, the US has a social scoring system (what we always accuse China of) but the only thing it tracks is how reliable you are about paying off debts. So with your home address, name, and SSN, basically anyone can take out loans or credit cards in your name. This will then damage your credit score, making it harder to get loans, buy a home, rent property, or even get a job.

That's why Americans are always concerned about having our identity stolen: because you don't need a lot of info to financially ruin someone's life.

[–] [email protected] 13 points 1 month ago (1 children)

I'm hardly the king of databases, but always using a surrogate key (either an auto-incremented integet or a random uuid) has done me pretty well over the years. I had to engineer a combination of sequential timestamp with a hash extension as a key for one legacy system (keys had to be unique but mostly sequential), and an append-only log store would have been a better choice than an RDBMS, but sometimes you make it work with what you have.

Natural keys are almost always a bad idea though. SSNs aren't natural, which is one pitfall: implicitly relying on someone else's data practices by assuming their keys are natural. But also, nature is usually both more unique than you want (every snowflake is technically unique) and less than you'd hoped (all living things share quite a lot of DNA). Which means you end up relying on how good your taxonomy is for uniqueness. As opposed to surrogate keys, which you can assure the uniqueness of, by definition, for your needs.

[–] [email protected] 273 points 1 month ago* (last edited 1 month ago) (51 children)

I'm sure folks on here know this, but you know, there's also that 10K a day that don't so...

What makes this especially funny, to me, is that SSN is the literal text book example (when I was in school anyway) of a "natural" key that you absolutely should never use as a primary key. It is often the representative example of the kinds of data that seems like it'd make a good key but will absolutely fuck you over if you do.

SSN is not unique to a person. ~~They get reused after death, and a person can have more than one in their lifetime (if your id is stolen and you arduously go about getting a new one).~~ Edit: (See responses) It seems I'm misinformed about SSNs, apologies. I have heard from numerous sources that they are not unique to a person, but the specifics of how it happens are unknown to me.

And they're protected information due to all the financials that rely on them, so you don't really want to store them at all (unless you're the SSA, who would have guessed that'd ever come up though!?)

It's so stupid that it would be hilarious if people weren't dying.

view more: ‹ prev next ›