this post was submitted on 18 Apr 2024
83 points (96.6% liked)

Ask Lemmy

26890 readers
3510 users here now

A Fediverse community for open-ended, thought provoking questions

Please don't post about US Politics. If you need to do this, try [email protected]


Rules: (interactive)


1) Be nice and; have funDoxxing, trolling, sealioning, racism, and toxicity are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them


2) All posts must end with a '?'This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?


3) No spamPlease do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.


4) NSFW is okay, within reasonJust remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either [email protected] or [email protected]. NSFW comments should be restricted to posts tagged [NSFW].


5) This is not a support community.
It is not a place for 'how do I?', type questions. If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email [email protected]. For other questions check our partnered communities list, or use the search function.


Reminder: The terms of service apply here too.

Partnered Communities:

Tech Support

No Stupid Questions

You Should Know

Reddit

Jokes

Ask Ouija


Logo design credit goes to: tubbadu


founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 22 points 7 months ago (8 children)

Oh there's a lot.

  • When I was a kid, parents and teachers used to teach, if you have sore muscles a day after an extensive workout, you need to work out even more in order to reduce the soreness. In fact, however, you need to rest those muscles.
  • I thought, pepperoni was pepper. (Like bell pepper, just smaller; similar to chilli). Then my girlfriend enlightened me after a confusing conversation, that pepperoni was a kind of salami. And then recently, at a company event before ordering pizza and after a very confusing discussion of what toppings we order, it turned out pepperoni was actually a kind of a salami, but not everyone agreed. So by now I've learned that pepperoni is neither of them. It doesn't exist. It's listed on pizza menus, and when you order it, you'll get something for sure, but you won't know in advance what it would be.
  • This isn't new, the realization was several years ago, but fits this list nicely: I thought, perfume was something for women. It turned out, there was perfume for men too.
  • Parents used to teach, if you read in the dark (on paper, not on a screen, I must add), you're ruining your eyes. But if you think about it: wtf does low light do to your eyes? By that logic, you're constantly ruining your eyes while sleeping.
  • For some reason I used to think, you could simply delete related entities bound by foreign key constraints in postgres, if you ran the query in a transaction. Once when I finally needed to do this, I learned the hard way I was wrong.

There's a lot more than this, probably I'll update this comment in the future. Or not.

[–] [email protected] 28 points 7 months ago (2 children)

I love how this comment covers super common misconceptions, but then throws a super specific database issue in at the end. Gotta have that cascade on delete, unless you want orphans.

[–] [email protected] 3 points 7 months ago

Or nullable FK , with on delete set null.
Or have a default value for the FK, and on delete set default.

load more comments (1 replies)
load more comments (6 replies)