andrew

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.

I ordered them through Lowes and they had all sorts of options for connectivity and power, including just old school chains. Looks like they’re Bali brand.

Haven’t watched the video yet, but I’m a huge fan of our plug-in z-wave smart blinds. Makes getting all that extra light way easier and automatable.

Maybe OP recycles the cups into filament.

Yeah, VR/AR is really amazing and has some pretty cool future applications. I’m glad Apple is investing in that future, too. But I kinda hope they don’t sink it with the potential this has to be a high profile failure because they went for a market segment that’s not going to see the benefits quite yet. Especially at the price point.

You could even just take the switch apart and rewire it to an IO pin, and then actually control the bulb socket with a relay. In that case you could have it truly integrated and nobody would notice a difference.

Well yeah. I guess if you want to DIY a solution there’s a lot more you can do. My issue is building a polished finished product rather than exposed wires and a switch, since I have the wife approval factor to consider now. So it’s easiest for me to buy a smart outlet and a button or switch vs wiring up my own solution and trying to 3d print a case these days.

I started off WiFi and ended up on zigbee for the most part. The major downside of wifi is how many devices are cloud/proprietary but it sounds like you’re using esphome so that’s not an issue. I definitely like my zigbee devices as they also tend to be slightly cheaper, but starting with WiFi is an easy progression definitely.

Getting a USB zigbee device is about all you need to get up and running and adding to your mesh, which I definitely recommend eventually.

The only real way I’ve found of doing stuff like this is another smart button or switch nearby. I use my buttons for whole groups of lights and toggles based on current state and whether you short/long/double click the button.

Appreciate the advice! I’ll definitely be keeping my ears open, then.

I’ve heard this a few times and honestly would love to do it. But I don’t really know where to get started. Any pointers?

I don’t, which is why half betazoid is a nice happy medium. Her mom on the other hand, would definitely not fall into the marry category for me.

I hear you can probably still get with crusher if she’s a ghost. She’s into that.

So kill Crusher. Bang Guinan, and marry everyone’s favorite empath.

IDK about child’s play but definitely enough for the lower decks engineers to clean overnight.

Isn’t that also my man Vic Fontaine? Can’t forget him.

I’m not anger. I’m disappointment.

One who speaks in tunnels is a tunnel linguist.

True, it’s probably microfusion reactors.

If it’s portable, that’s a game changer.