

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.
Linux server admin, MySQL/TSQL database admin, Python programmer, Linux gaming enthusiast and a forever GM.
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
Short version: he might have frozen hiring air traffic controllers, he might not have. The ambiguity caused de facto hiring freezes in a profession that was already understaffed and vital to air safety.
There is a legitimate argument to be made with reasonable people on both sides as to exactly how old is old enough to confidently say that there’s not a power imbalance due to age alone. Whether that’s 18, 21, 24 or some other number is an open question.
30+? If they wanna date somebody more than double their age, that’s completely their business.
I smoked for pretty much my whole life. Quit with varying degrees of success many many times. I switched to nicotine pouches 2 months ago, and it’s been fairly great at reducing the damage of cigarettes while not dealing with the actual addiction.
Still need to watch out for gum recession, so it’s not exactly 100% healthy, but smoking causes gum recession anyway and I’m not destroying my lungs anymore, so pretty solid for harm reduction.
Game isn’t letting me. Apparently I need to expel diplomats and lower relations first.
The thing is, they can’t. It’s a unified market. Any tarrif against Denmark is by definition a tarrif against the EU.
Non-German but I am in the EU. Didn’t find it odd at all. Just assumed it was “flow market” in German.
Maybe this’ll finally be the event that causes Canada to drop those ridiculous internal tarrifs and trade barriers.
What if they’ve been studying Bulgarian body language? Then the head shake will be interpreted as “Yes”.
The new Chinese LLM, DeepSeek, has caused a US AI stock market crash. The best analogy I read, elsewhere on Lemmy that icba to dig up right now, is that while Nvidia has been insistent that you need their Rolls Royce or you have to walk, a Chinese company has released an affordable family car.
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.
“I don’t want to carry bags all that way!”
Here. Take a backpack.
Not Invented Here. Basically, reinventing the wheel just so they can have full control of a project.
Sorry, legacy code and technical debt. Please check in with us in ~2000 years or so, we might have the next minor bugfix version up by then.
Many people (not all) rent because they can’t afford to buy, not because they don’t want to own property.
Has there been any progress on dropping tarrifs between provinces?