![](https://lemmy.stuart.fun/pictrs/image/910b6b99-09cf-4901-ba16-a9b3fff89e56.png)
![](https://lemmy.ml/pictrs/image/c0ed0a36-2496-4b4d-ac77-7d2fd7f2b5b7.png)
Plus you have plenty of time to tumble once or twice while your large codebase compiles.
Just chilling
Plus you have plenty of time to tumble once or twice while your large codebase compiles.
Yeah, this is pretty textbook selection bias.
The real primary benefit of storing your relationships in a separate place is that it becomes a point of entry for scans or alterations instead of scanning all entries of one of the larger entity types. For example, “how many users have favorited movie X” is a query on one smaller table (and likely much better optimized on modern processor architectures) vs across all favorites of all users. And “movie x2 is deleted so let’s remove all references to it” is again a single table to alter.
Another benefit regardless of language is normalization. You can keep your entities distinct, and can operate on only one of either. This matters a lot more the more relationships you have between instances of both entities. You could get away with your json array containing IDs of movies rather than storing the joins separately, but that still loses for efficiency when compared to a third relationship table.
The biggest win for design is normalization. Store entities separately and updates or scans will require significantly less rewriting. And there are degrees of it, each with benefits and trade-offs.
The other related advantage is being able to update data about a given B once, instead of everywhere it occurs as a child in A.
At least you know better than socks with sandals!
If you’re color blind enough, this could be either!
Can we joke about log4shell? Maybe heartbleed?
Piracy is just staying over at a friend’s house.
A few days of my pain in exchange for months of glory and beyond.
Can this power be learned?
How very apt that Hollywood would be so skilled at projection.
Well my owner is definitely getting his money back or starting a class action suit for false advertising.
I’m pretty sure they blame the others for not being more careful and that they if only they slipped and fell more often it wouldn’t hurt so much.
Yes and then they get drenched and track it all over the house causing others to slip and get hurt.
They should just require ships to bring their own water to replace it. 🧠
This is floating point. We also need to know what happens when you escape with -0.
My time perception is so screwed these days. I could have sworn I’ve been here a few years at this point.
That’s been my experience for 95% of Lemmy communities right now, though. I don’t know if it will last but for now, it seems pretty high quality.
It’s cool, it’s probably just self extracting. For convenience!