jacksilver
@jacksilver@lemmy.world
- Comment on Games franchises that need metroidvania spinoffs? 6 days ago:
It already exists, but the sands of time Metroidvania “Lost Crowns” was surprisingly good.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 week ago:
Thanks, OP seemed more curious about the technical aspects than just the absurdity of the comment (since pretty much every business uses SQL) so hoped a more technical explanation might be appreciated.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 week ago:
Sure, basically any time you have a many-to-many relationship you’ll have to repeat keys multiple times. Think students taking courses. You’d have a students table and a courses table, but the relationship is many students take many courses. So you’d want a third table for lookups where each row is [student_id, course_id].
This stackoverflow post has a similar example with authors and books - stackoverflow.com/…/how-do-i-model-a-many-to-many…
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 week ago:
If SSNs are used as a primary key (a unique identifier for a row of data) then they’d have to be duplicated to be able to merge data together.
However, even if they aren’t using ssn as an identifier as it’s sensitive information. It’s not uncommon to repeat data either for speed/performance sake, simplicity in table design, it’s in a lookup table, or you have disconnected tables.
Having a value repeated doesn’t tell you anything about fraud risk, efficency, or really anything. Using it as the primary piece of evidence for a claim isn’t a strong arguement.
- Comment on Doordash deserves it's fate 1 week ago:
Yeah, every few months we might get something delivered (sometimes on a rainy day for example), but we made a rule about picking up food once food prices started rising and it the delivery was adding $20 to the orders.
- Comment on Will online only "Device Activation" become the norm for every device in the future? / Will everything require an app in the future? 2 weeks ago:
If you want to limit consumer decisions to subscription vs no-subscriptions than sure, but subscriptions are just one element of the choices people have to make.
You also have issues like data privacy, ethical labor, maintainability, etc. Too many things for everyone to keep up with and effectively vote with their wallet.
- Comment on Will online only "Device Activation" become the norm for every device in the future? / Will everything require an app in the future? 2 weeks ago:
There are a couple of problems with this logic and it’s why regulations are critical to a functioning world.
- Frequently people need something today(ish) and don’t have the luxury to wait. Food is a great example, but depending on the person/entity most things can end up being urgent (like I need a laptop today for work/school)
- No one knows the ins/outs of every industry. While Lemmys more technical users can see the issues with so many accounta/subscriptions, that doesn’t mean the general public does.
Its certainly more nuanced than that, but that’s just a quick breakdown of the challenges of voting with your wallet.
- Comment on Ubisoft announces studio closure as it lays off 185 staff 3 weeks ago:
True but if I own the .exe or physical disk, it’s going to be a lot harder to stop me playing the game than if I’m accessing it through a platform.
- Comment on Ubisoft announces studio closure as it lays off 185 staff 3 weeks ago:
Yeah, that’s the point I and the person above were stating.
- Comment on Ubisoft announces studio closure as it lays off 185 staff 3 weeks ago:
You are right - pcgamingwiki.com/…/The_Big_List_of_DRM-Free_Games….
My main arguement though was that it’s not like your steam library is yours without restrictions. You’re agreeing to Steams terms and services and there are lots of ways they can prevent you from playing (most) games you “own”.
- Comment on Ubisoft announces studio closure as it lays off 185 staff 3 weeks ago:
I don’t get the downvotes. You’re right, everything you “own” in steam is through a license. People just don’t like to admit that we’re willing to let that one slide for convenience.
- Comment on Trump tariffed Columbia in response to not letting a plane of deported illegals in. 3 weeks ago:
The general issue with actions like this is that you expend political capital. You can build political capital in a lot of ways, but many of Trumps actions burn through it rather than build.
Why this matters is that the USA benefits from being a/the world leader, but that can only continue while other countries want that. Once the US shows itself to be unreliable or obstructive countries will look to places like China instead. So short term gains, long term costs - just like how many companies in America act.
- Comment on Steven Spielberg Says He Fought to Stop E.T. Sequel From Being Made 3 weeks ago:
Jo Miran below mentioned this, but they took elements from the book/potential sequel when making the ET ride at Universal.
- Comment on Kennedy Would Keep Stake in H.P.V. Vaccine Suit if Confirmed 4 weeks ago:
This, abortion, more oil, and more are all going to hurt us.
- Comment on Is there any non-zero possibility Musk was not doing a Hitler Salute? 4 weeks ago:
Yeah, if any normal person did a nazi salute by accident, they’d be all over the news refuting it. If he isn’t, then it seems to default to being a nazi salute.
- Comment on Is there anything my girlfriend and I have to consider when traveling to America based on our skin differences? 4 weeks ago:
As many people said there is racism in the US, but that’s cause everywhere has its flavor of racism.
If you’re visiting the US as tourists it’s highly unlikely you’ll encounter anyone being outwardly racist, especially if you keep to major tourist destinations.
In any major US city you’ll run into people of all different colors and people from all over the world working and living together, just like most big/international cities.
- Comment on GTA VI Might Inspire Other AAA Developers to Price Their Games at $100 4 weeks ago:
Honestly this could all be a campaign from Rockstar to get ahead of higher pricing. They throw out $100 to some random people and let them run with it, so when they announce a $80/$90 price tag everyone bregurdingly goes along with it.
- Comment on Marvel Snap is banned, just like TikTok 4 weeks ago:
Hmm, I may be reading it wrong, but it’s just talking about the distribution/updating of foreign controlled applications. Based on what I’ve seen Marvel Snap isnt controlled by them, they just provide services for the application, so it wouldn’t technically apply. However, I’m not a lawyer and may have the wrong read on the app, but given the game developers were surprised I’d think that’s the right read.
- Comment on Marvel Snap is banned, just like TikTok 4 weeks ago:
I feel like bytedance is doing this on purpose to rule people up, as these kinds of services weren’t explicity called out.
It may backfire though. I don’t think most Americans know how much is influenced/owned by Chinese companies.
- Comment on Don’t Look Up director says ‘half a billion people’ have now seen film despite critics 5 weeks ago:
I only saw it cause it got a Oscar nomination and agree with the critics on this one.
It all felt a little off, like it was trying to be too many things at once. It jumped back and forth between what felt like parody/comedy/drama to the point it failed to do any particularly well. Or maybe it was a little too surreal to pull off the seriousness of the topic.
- Comment on How is the current AI bubble when compared to the .com bubble in the early 2000's? 5 weeks ago:
Thanks for the context, that all makes sense to me.
- Comment on How is the current AI bubble when compared to the .com bubble in the early 2000's? 5 weeks ago:
When you say “document your code” what kind of documentation are you talking about?
- Comment on Lil Gator Game: In The Dark | Announcement Trailer 5 weeks ago:
Yeah I liked the free form exploration, felt more like a kid on an adventure.
I my opinion this game did open world design better than most games out there. I personally put it above BOTW, but that’s probably a controversial opinion.
Really excited to hear they’re making a sequel.
- Comment on Nintendo will reportedly reveal Switch 2 this week | VGC 5 weeks ago:
If you didn’t try it, “Bowser’s Fury” was a lot of fun. It’s annoyingly packaged with “3D World”, although if you haven’t played that it’s also a good 3D Mario.
- Comment on Why So Many Video Games Cost So Much to Make 1 month ago:
I suspect this is an area where we may see AI assets help speed up development for smaller studios.
- Comment on Microsoft is combining “the best of Xbox and Windows together” for handhelds 1 month ago:
Steam already runs fine on Linux, you don’t need SteamOS to us the compatibility functionality, meaning anything you can play on the steamdeck already works on a Linux pc.
- Comment on In The Lost Lands - (First Poster) Bautista & Jovovich. Dir: Paul W. S. Anderson 1 month ago:
I mean just look at his left foot (our right). It’s literally not stepping on anything!
- Comment on What's the greatest joy you have gotten from a video game? 1 month ago:
Same, me and a friend struggled with that game for a while, but still remains an extremely satisfying game to have beaten when you couldn’t just look things up.
- Comment on What's the endgame when the rich have all the money? 1 month ago:
But they’re the minority, most games have gatcha/pay-to-win mechanics. It’s actually hard to find some simple games where you aren’t harassed to buy things.
- Comment on There is a fee to close my HSA account 1 month ago:
To simplify both posts below:
-
FSA: good if you know you’re going to have $2-3k+ medical expenses and want to use tax deffered money.
-
HSA: good if you want to save tax deffered money year over year (and don’t mind having a high deductible insurance plan)
-
additionally, some people use HSAs as an investment for retirement.
-