having is less annoying way of not doing needless/bug-prone repetition. if you select someCalculatedValue(someInput) as lol you can add having lol > 42 in mysql, whereas without (ie in pgsql) you’d need to do where someCalculatedValue(someInput) > 42, and make sure changes to that call stay in sync despite how far apart they are in a complex sql statement.
most languages have some first or third party lib that implements a query builder
General deep dives on random topics:
stuff about the animal world:
linguistics and how we communicate:
You just apply anyway.
Usually they’re not willing to pay anywhere close to doctorate money for doctorates anyway, and will end up settling no matter who they pick.
I’m not sure if i’ve ever known any engineer who has met the listed job requirements for their role. They say requirements, but what they mean is “this is my ideal”. Put another way: think of it like a dating app profile. dude may act like he only dates 10s in his profile, but you show him some attention and suddenly you’re just as good as a 10, because he’s lonely and needs affection from someone.
Basically, for most companies, they’re essentially the corporate version of incels. Way too high of standards, but will settle for anyone who is into them regardless of what they think their standards are, because they just need someone ASAP, and their standards disappear quickly once you make yourself available.
I’ve enjoyed a 20+ year long career as a programmer, and I dropped out of college 3 months in because i couldn’t afford it. That’s because early in my career i took a few shitty jobs until i had a decent enough resume that i didn’t have to take shitty jobs anymore. That took study and practice and passion in programming, but i did that for fun years before i even showed up on the university doorstep.
Same except i dropped out of college 3 months in and have enjoyed a healthy career for the last 20 years anyway.
It’s not really editing titles. They publish it with various titles that get split-tested at first, whichever version of the title gets more clicks then becomes the only title used.
well sure. i’m not saying people should be calling them lego bricks. it’s fine to call them just legos or lego.
but i think you missed my point, which was: don’t get all preachy about “you have to call them lego, you can’t say legos because it’s wrong”, when it’s equally as fucking wrong to call them lego. The company tells you to call them lego bricks, so if you’re going to go around telling people that one thing is wrong, you shouldn’t be telling them to instead use something else which is also wrong, because then you’re just being a douchebag.
The equivalent here is if you were to call the markers “sharpie” as a plural, and go around confidently telling other people they’re wrong for saying “sharpies” because “look the company calls them sharpie permanent markers, so the proper plural form is obviously sharpie, just like how it works with dice/die” (which, again, there is no way in which the lego or sharpie situations are similar to the pluralization of die).
I mean, i just say legos and don’t get all fucking judgy about what other people say.
I do also get all judgy about other people getting judgy about what people say in this case, but i feel justified in that behavior.
That was what was implied by my “don’t be douchey about it” suggestion :)
No, it’s LEGO bricks. LEGO is the brand name. If you want to be pedantic AND correct, you should be referring to them as “LEGO Brand construction bricks”, though if you’re referring to a boxed set, it’s “LEGO brand construction brick playset”.
Or you could just not be douchey about it. Either way there is no connection to dice/die.
So here’s the thing. The whole west coast of NA, including california, oregon, washington, and BC are considered to be super liberal areas. This is true by a majority of the population, but all of these regions are still filled with people who are as conservative as any other rural area in the US. It’s just that in those regions, more people populate the large cities than the rural areas.
Really, conservatism reigns in poorer, less educated, and more isolated regions with low population and without diversity, where tribalism can run rampant; it’s easy to be a racist shitbag if you barely meet anyone with a different skin color than you. Liberalism thrives in regions with diverse populations where in order to live we have to cooperate with others.
I live in Portland, Oregon. People tend to think oregon is a blue state wonderland (except during covid and the floyd protests. then apparently the whole city was on fire and in a state of complete anarchy; spoiler— it totally wasn’t). That’s not the case. We just have enough people in large cities to outnumber the racist cuntballoons in the rural areas. And that’s what the whole west coast is like (and basically every “blue state” in the US)
Western Canada is a lot like western USA. Filled with shart-gargling racists/homophobes/transphobes, but outnumbered by people who aren’t pieces of shit.
west coast (and especially PNW) culture is just “we kinda outnumber them slightly”, but the overall issue comes down to: in rural/conservative areas, it’s easy to be racist/homophobic/transphobic/other-religions-phobic, because you never have to consider anyone’s feelings that hurt your worldview because you don’t know them personally and do not consider them to be human on the same level as you.
Along these lines, i’m thrilled with the ps portal as well. was only $200, but the ps online streaming is so good. i used to use it on ps4 on my ipad with an external controller from 1200 miles away at legit decent frame rate and latency.
ps portal’s display is crisp and beautiful, it looks so much more gorgeous than the steam deck (because all the rendering is done on the ps5), and there are some games that i don’t even really want to play on the big screen format that the portal has made awesome because they’re wonderful on handheld format.
best gaming purchase i’ve made in a long while
done 👍
i could use a good ground screw myself
wait, what community am i in?
The “J” in “J & L(auren)” is MISERABLE
My grandpa was german. In german, jetztwhich in english would be pronounced something like “yetst”, means “now”. His whole life he would use “yet” in place of where an english-native speaker would say “now”, and i always thought that was adorable.
Those hurt my lungs so much more.
Dry flower vape is super nice, it has a way more subtle savory flavor and the smell goes away quicker. If you can afford it, i highly recommend the mighty+ (or their cheaper model the crafty+) by storz&bickel (same company that makes the OG device, the volcano).
I will never require a spider button on my keyboard
A large part of the problem here is that people have been trying to artificially grow lemmy posts via bots that repost both articles from reddit, and random news articles from various sites.
you really can’t beat mighty+, i’ve been using mighty/crafty exclusively for about 8 years and im constantly disappointed by every other dry flower vape i’ve ever tried in comparison