Barbarian
@Barbarian@sh.itjust.works
- Comment on After Years of Struggling To Be Noticed, My Indie Game Was Covered By VICE 22 hours ago:
Wow, it’s almost like there might be people with different opinions that use Linux and Linux users aren’t a single hivemind.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 day ago:
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.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 day ago:
It’s necessary to split it out into different tables if you have a one-to-many relationships. 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 person.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 day ago:
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
- Comment on aww man here we goo... 1 day ago:
- Comment on [deleted] 2 days ago:
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 inbetween is an open question.
30+? If they wanna date somebody more than double their age, that’s completely their business.
- Comment on Flohmarkt - a Fediverse replacement for Facebook Marketplace 1 week ago:
Non-German but I am in the EU. Didn’t find it odd at all. Just assumed it was “flow market” in German.
- Comment on Trying to earn a record for "youngest person to <insert a thing>" is just an IRL speedrun 4 months ago:
Playing on the highest difficulty level
- Comment on The Most Loved Digital Audio Streaming Platforms. 4 months ago:
Another Deezer user in the wild! Been a subscriber to it for years now.
- Comment on Multiplayer shooters should get "pure" healers that can't shoot 4 months ago:
Need a dispenser here!
- Comment on Norway is mulling building a fence on its border with Russia, following Finland's example 4 months ago:
"A border fence is very interesting, not only because it can act as a deterrent but also because it contains sensors and technology that allow you to detect if people are moving close to the border,” Justice Minister Emilie Enger Mehl said
A fence won’t stop anyone, but it can detect people, which sounds like the point.
- Comment on Youtube has fully blocked Invidious 4 months ago:
Thanks for the link, it was a very interesting read. While it is disappointing that it’s not actually a collective (assuming this blog post is accurate), having a platform run and owned by 6 content creators is still better than YouTube’s governance structure.
- Comment on Youtube has fully blocked Invidious 4 months ago:
An advantage of funding things via a collective like Nebula as opposed to each individual creator managing their own patrons is that new creators can start making bigger, more expensive projects quicker. Even established creators have this advantage, they can take bigger risks on bigger projects with the safety net of a share of the nebula pie.
- Comment on How is Lemmy better than Reddit? 5 months ago:
anti-anything google
I hear that. Went through the technical reasons for the manifest V2 deprecation (if this is only to target unlock origin, why did they implement filter lists into the browser? Why does unlock origin lite work just fine?) and it got down voted to oblivion. Haters gonna hate I guess :))
- Comment on #StopKillingGames Update: Sweden and Poland pass threshold as initiative reaches 25% 5 months ago:
While we’re on the topic of EU initiatives, the tax the rich initiative, aiming to set a floor on tax rates for the very wealthy, and have member states use that new money for environment, employment and social policies.
- Comment on I know this is PatientGamers, but can we discuss how even the current generation of consoles seems to ask for patience as they aren't that many games 4 years after their release? 6 months ago:
Abandon consoles. Embrace inevitability of the PC master race.
- Comment on First overseas trip with my girlfriend – Any tips to make It our best trip? 6 months ago:
Tourists in Bulgaria, for example, always get caught out by this. They shake their head for yes and nod for no.
- Comment on First overseas trip with my girlfriend – Any tips to make It our best trip? 6 months ago:
Exactly what I wanted to say. All that talk of “perfection” makes me imagine them snapping and going full psycho because a train was cancelled and they need to book a different one.
- Comment on Devs should not be "forced to run on a treadmill until their mental or physical health breaks", says publisher of Manor Lords, citing how gamers seem to be trained to expect endless content work now 7 months ago:
Good thing I double-checked to see if someone else made this point yet.
Yeah. Not only that, but the splash screen when you launch the game makes it incredibly clear that it’s one guy called Greg (very humanizing) and he’s working on it, but he’s not some superhero.
- Comment on Google Search Ranks AI Spam Above Original Reporting in News Results 7 months ago:
So basically the Lemmy version of Subreddit Simulator, but allowing users as well?
- Comment on Google Search Ranks AI Spam Above Original Reporting in News Results 7 months ago:
Yes, absolutely. That is a concern that I too share, fellow meat being. We should be vigilant against superior, more capable, and really friendly artificial intelligences.
- Comment on WTF is wrong with Killing Floor 2? 8 months ago:
You can always refund it
- Comment on Would lemmy benefit of implementing Polls? 9 months ago:
Should be an option to allow/disallow non-instance users to vote. That’d be really useful here in sh.itjust.works for the Agora.
- Comment on Vanguard takes screenshots of your PC every time you play a game 9 months ago:
It depends. There’s 2 different methods that I don’t think they’re doing that would make it legal:
-
Explicitly tell the user what data the anti-cheat collects when you install it, and what other companies have access to it.
-
Anonymize the data. Crop the screenshots in storage media to just the game screen, and have a list of which games need what sections of the screen blurred to remove usernames.
The first is far more useful for them than the second, but it also undermines it’s functionality ad an anti-cheat because you’re telling the cheat creators what to guard against.
Of course, the real answer here is stop doing user-side anti-cheat at all, do it server-side, and trust nothing the client says. That’s more difficult than user-side, but it also has the benefit of working, while also respecting the user’s privacy.
-
- Comment on The big hit medieval strategy game Manor Lords works well on Linux 9 months ago:
Yup! The performance gets pretty terrible towards the lategame, but as far as I understand it, that’s a general issue atm, not Linux specific.
- Comment on space 9 months ago:
Primer is one of my favourite movies ever. It was made on a budget of 3 peanuts and pocket lint, and it shows, but damn it’s an interesting premise.
- Comment on Welcome to the Golden Age of User Hostility 10 months ago:
Actually, that’s not the real reason patents are public. The reason is to allow everyone to freely use the patent after the expiry.
The tradeoff is supposed to be the inventor gets exclusive use for a decade in exchange for detailing exactly how the thing works for everyone else.
- Comment on Hasbro exec says Baldur's Gate 3 "proved for us that people really wanted great D&D games," supports Larian's plan to "take the time we need" 10 months ago:
play better games
I’d heavily recommend people who want to play DnD but better and without Hasbro look at Pathfinder 2e. Fixes all the major issues with DnD (boring combat where melee gets glued to each other due to attacks of opportunity, no variety in actions outside of magic, broken balance, mandatory healer, etc) while also being produced by the only unionized TTRPG company.
- Comment on Kids Are Watching Brain Melting AI-Generated Videos on YouTube Without Parents Realizing 11 months ago:
For the families who can afford it, daycare is the replacement.
- Comment on Kids Are Watching Brain Melting AI-Generated Videos on YouTube Without Parents Realizing 11 months ago:
“It takes a village to raise a child” is an old expression for a reason. Historically, parents wouldn’t take care of their kids 24/7. They would have grandparents, aunts, neighbours and friends to help share the load.
The modern idea that parents and parents alone do 100% of everything to raise a child is a very modern western thing.