Yeah, I work daily with a database with a very important non-ID field that is denormalized throughout most of the database. It’s not a common design pattern, but it is done from time to time.

It’s necessary to split it out into different tables if you have a one-to-many relationship. Let’s say you have a list of driver licenses the person has had over the years, for example. Then you’d need the second table. So something like this:

SSN_Table

ID | SSN | Other info

Driver_License_Table

ID | SSN_ID | Issue_Date | Expiry_Date | Other_Info

Then you could do something like pull up a person’s latest driver’s license, or list all the ones they had, or pull up the SSN associated with that license.

Theoretically, yeah, that’s one solution. The more reasonable thing to do would be to use the foreign key though. So, for example:

SSN_Table

ID | SSN | Other info

Other_Table

ID | SSN_ID | Other info

When you want to connect them to have both sets of info, it’d be the following:

SELECT * FROM SSN_Table JOIN Other_Table ON SSN_Table.ID = Other_Table.SSN_ID

EDIT: Oh, just to clear up any confusion, the SSN_ID in this simple example is not the SSN itself. To access that in this example query, it’d by SSN_Table.SSN

There’s another factor that nobody mentioned: the sales tax in EU countries is different for different products. This allows countries to incentive or disincentivize different classes of products by ramping the sales tax up or down. Higher tax on junk food, cigarettes and/or alcohol, low or nonexistent sales tax for basic ingredients and medicine.

Interestingly, France and the Czech republic tax wine and beer respectively like basic food.

Romanian would be either “I’ll put my feet in it” or “I’ll put my dick in it”

Many people (not all) rent because they can’t afford to buy, not because they don’t want to own property.

(remember, your aunt charging below market is the exception, not the norm)

Isn’t this definitionally true? The norm, by definition, is the market rate.

Russia prefers a destroyed world over an intact one without Russia.

That much is true, but none of this is existential. If the Russian military packs up and heads home, Russia continues to exist. They don’t want to do that ofc, but obviously Russia prefers an intact world with Russia compared to a destroyed world.

Technically yes, but I don’t mean technology as phones/laptops/tablets/etc. Imho, the biggest factor in social isolation is atomization due to bad urban planning. When everything and anything is only accessible by car, you lose any connection with your local neighbourhood and local stores/cafes/etc.

In environments where people walk around the neighbourhood, doing small daily shops, going to local businesses and taking mass transit to work/school/restaurants/bars, then you’re much more likely to interact with people rather than driving around in your social isolation-mobile.

Urban planning can be considered a form of technology, which is why I said technically yes.

EDIT: Oh, another big factor here is the loss of the third place. It still exists in some places (local pubs in British towns, local coffee shop in Portugal, etc), but in places without a socially normal “hangout spot” that is separated from both home and work/school, it’s much harder to meet acquaintances which may in time become friends.

Presumably Valve’s lawyers can make this case, so I guess we’ll see if the judge is receptive to it.

Works for floors!

Hungary is blocking every single sanction package on Russia. They do not send aid to Ukraine at all and even block aid shipments through Hungary.

All of these are very fair points. My point was that they’re happy to publicly call for “peace and an end to the war” while throwing Ukraine under a bus, but simultaneously they’re for NATO protecting them against Russia.

They also blocked Swedens NATO membership for ages.

If I’m not mistaken, this wasn’t a pro-Russian thing, this was a blackmail NATO allies for concessions in exchange for agreeing thing.

None of the Bucharest 9 have. Hungary may make loud noises, but even they were cooperating with this group to increase defence against Russia.

Blink-blink-blink. Blink. Blink. Blink. Blink-blink-blink.

No, I don’t have something in my eyes, I swear I’m fine looks nervously at boss.

3rd time’s the charm! And also according to this map they didn’t even have to split it with Russia this time.

For players of strategy games, CAS suffices. No idea if militaries do it differently. Saying you’re going to an automatic teller machine would be awkward to say as well.

LLM’s aren’t real AI

I think that’s mostly a semantics issue. When people talk about AI here on Lemmy, they generally mean AGI. LLMs are not AGIs, as far as I understand it.

anti-anything google

I hear that. Went through the technical reasons for the manifest V2 deprecation (if this is only to target ublock origin, why did they implement filter lists into the browser? Why does ublock origin lite work just fine?) and it got more downvotes than upvotes. Haters gonna hate I guess :))

This video does an ok job of it.

Abandon consoles. Embrace inevitability of the PC master race.