most programmers aren’t DB experts and the SQL they output is quite often terrible.
Isn't that looking at it the wrong way / missing the point?
If you're fine with simple queries, use an ORM of your tech stack. Once you have to understand querying performance and weigh usage patterns, constraints, and cache performance and size, then it's not about SQL anymore. It's about understanding the DBMS you use.
You may ask "why can't I use a different language for the querying part of it". But I haven't seen anything better yet.
Having a common, well-understood, established, documented, inter-product compatible language has a lot of value. Using a different language to the well-established industry standard is in itself an increased hurdle to adoption.
Getting back to the original quote: I don't think anything else would serve bad developers / non-experts any better.
I was missing a "don't know"/"can't determine" option.
For photographs specifically and some types of paintings/artificial stuff, there are things you can look for. But for other things, I feel like, or at least to my knowledge, you can't.
Like the pencil drawing. There's not enough things it could be doing wrong. It's a sketch. With simplistic but "error-excusing"/diffuse/transformable content.
A skeuomorph is a derivative object that retains ornamental design cues from structures that were necessary in the original. Skeuomorphs are typically used to make something new feel familiar in an effort to speed understanding and acclimation. - Wikipedia
The designers on my project actually designed such a non-telling unprofessional-tone "oops" error page.
Colleague implemented it like that, but on review we agreed it's just bad, and suggested/implemented an actually useful, professional error page.
It baffles me how people can implement actively useless stuff like that. And it even showed up in my team. I was somewhat surprised. I'm glad I'm Lead, and have direct communication with the customer. Two ways to prevent and improve things like that. At least in my projects.
I'm confused whether you see the entire people as only one individual? Very extreme view to say "if they can't dominate forget anyone opposing or evading oppression, as well as chances for contrary information transmission".
Continuing to question is important for when chances arise. There's also activism and guerilla sabotage. That's more than ineffective questioning.
How does VPN blocking that you support help? It does the opposite.
I think that's what we see and may be misattributing of a small active subset that is very technical and invested.
It's on the steam store. I'm sure many people buy and play, and don't ever read or write on a community like this. They're "invisible" here, but impact if not dominate the playtime ranking.
Post a link to a channel of 1k users and 1k users send a request to the website, instead of only the server once?
/edit: From a privacy standpoint I'd really trust my chat server provider over random websites. So I definitely don't see how it's a terrible choice for these two reasons.
That being said, if you're concerned, disabling previews is the answer.
Title talks about "the internet", your text talks about "social media" - and threads so seemingly a subset of social media.
The internet doesn't make it hard. It's incredibly easy. Sending emails is easy. Hosting a website is easy. Posting to platforms is easy.
Platforms and communities restrict - through their own rules - what they deem acceptable within their own scope. That's more about defining scope than "making it hard".
Reasonable self promotion is often accepted on reddit and lemmy. Blatant advertising is not. Be part of the community, or run an ad for an ad. Be a good participant rather than a spammer.
One of the first popular lemmy communities was one for announcing and therein promoting your own communities.
Talk to N and mother first. Open with your personal concern, and experience - to explain why you care, your good intention, and to give significance/urgency to the issue at hand
Offer your help in supporting them in their efforts. Discuss with them how they see it, the state they're in, what they can do and influence.
I'd consider two approaches - not one or the other, but chase/asses both.
Limit access to funds, secure funds for needs
Help them (G) with their addiction and spending - this is very dependent on their personality, view, openness, and personality + your approach to them. Working together with N and mother is essential
If they don't want your help, or don't see any approaches as feasible, accept it as it is and that you can only do so much and not help everyone even if it's in your capability and interest.
There is no inherent purpose.