> Addiction is ... a persistent and intense urge to use a drug or engage in a behavior that produces an immediate psychological reward, despite substantial harm and other negative consequences
Immediate psychological reward = dopamine hits from likes and shares
Harm and other negative consequences = anxiety, depression, low self-esteem, FOMO, less connection with friends and family, etc...
Food is not as easy to make addictive because the psychological reward diminishes as you get full. The exception to this is people with an eating disorder, who use eating as a way to cope with or avoid difficult feelings.
But that's it. There was no win because the opportunity to even compete was taken away. Imagine you train your whole life and finally win the Olympic Gold medal, but everyone knows it's only because the true nr 1 ignored to compete in this format.
Winning a title is never about facing the greatest possible opponent. Even the people who show up aren’t at their absolute best, but consider everyone who doesn’t devote their lives to the sport. The greatest potential chess player of all time likely does something else with their lives.
Without prep Magnus would be vastly less likely to win, and he’s not doing the prep because he’s not competing. How exactly is that different than someone not devoting themselves to the sport 20 years ago?
I make no claims about what’s going on in people’s heads here just the underlying reality.
I was pissed I didn’t go to nationals in high school largely because I got no sleep the night before due to a crappy hotel stay. Losing a close game to board 1 while trying to stay awake sucked, but I was hardly the only person off my game, so that’s just how things workout.
I've used SQL for around a decade and also never came across it. I'm maintaining SQL code with hundreds if not thousands of basic primary key joins and this could make those queries way more concise. Now I want to know the reasons for not using USING!
First, you need to be aware of the implicit disambiguration. When you join with USING, you are introducing a hidden column that represents both sides. This is typically what you want - but it can bite you.
Consider this PostgreSQL example:
CREATE TABLE foo (x INT);
INSERT INTO foo VALUeS (1);
CREATE TABLE bar (x FLOAT);
INSERT INTO bar VALUES (1);
SELECT pg_typeof(x) FROM foo JOIN bar USING (x);
The type of x is is double, - because x was implicitly upcast as we can see with EXPLAIN:
Arguably, you should never be joining on keys of different types. It just bad design. But you don't always get that choice if someone else made the data model for you.
It also means that this actually works:
CREATE TABLE foo (x INT);
INSERT INTO foo VALUeS (1);
CREATE TABLE bar (x INT);
INSERT INTO bar VALUES (1);
CREATE TABLE baz (x INT);
INSERT INTO baz VALUES (1);
SELECT \*
FROM foo
JOIN bar USING (x)
JOIN baz USING (x);
Which might not be what you expected :-)
If you are both the data modeller and the query writer - I have not been able to come up with a reason for not USING.
Thanks for the reply. The use case I have in mind is joining onto an INT primary key using a foreign key column of another table. This alone would remove a massive amount of boilerplate code.
Whenever someone complains about being treated "worse than dogs" I have to wonder how they think dogs should be treated. To be fair, if dogs could catch COVID and pass it onto humans they'd likely have banned unvaccinated dogs as well.
Of course. After living in Germany I can say that if I has not been not insulted in the process and the staff did not glare at me like I'm interrupting their free time, then the service was already much better than average
> Addiction is ... a persistent and intense urge to use a drug or engage in a behavior that produces an immediate psychological reward, despite substantial harm and other negative consequences
Immediate psychological reward = dopamine hits from likes and shares
Harm and other negative consequences = anxiety, depression, low self-esteem, FOMO, less connection with friends and family, etc...
Food is not as easy to make addictive because the psychological reward diminishes as you get full. The exception to this is people with an eating disorder, who use eating as a way to cope with or avoid difficult feelings.
reply