Alexa? :D

nearer the coordinator, twice for the far one.

Heh, there’s the special case of the kitchen ones. My kitchen is some kind of pseudo-Faraday cage. Wi-Fi gets blocked almost completely (I have a cabled repeater in the kitchen just for reliable Wi-Fi in there …), Zigbee does slightly better (probably because there’s a Zigbee light just outside the kitchen, but it depends on the position, so my first few tries seemed to work without an issue, but the battery just dropped, after 1 year it went through two batteries. I found a different spot for it, and now it works normally :D

edit: I should also mention that I have 2 ZigBee routers in the kitchen, which seem to just work normally. I honestly just gave up wondering about WTF my kitchen does to signals.

Thanks, so it looks like it does need LMS. Which is just a huge amount of complexity for a single speaker. I don’t need multi-room audio or even multiple speakers. It’s literally one speaker in the kitchen, and I do have a media server set up.

I don’t really mind either way, but I feel like you and sibling commenter are thinking of something obvious that is eluding me: What speaker do I get?

But wouldn’t that bring me back to my question of what speaker to use?

Thanks, I’ll have a look at it.

you need an account for plugin

What exactly does that mean? Registering and logging in once to install the plugin would be acceptable, having to have further internet access on the device would not be.

You misunderstand. I don’t want my voice for music selection anymore ;) All I want is for HA to be able to mute the speaker when I want to use my voice for something different. Bluetooth is not even a preference, that would only be the worst case of streaming from my phone instead of Jellyfin.

FWIW, I bought my first Aqara temperature & humidity sensors 4 years ago, and I only changed the battery twice despite getting cheap bulk Varta (0.7-0.8€ each) from Amazon.

Thanks, is my understanding correct, that I’d need an extra server, though? And it can’t just support Jellyfin as streaming source (e.g. via DLNA)?

The one problem with Aqara devices is they don’t properly follow the Zigbee standard, and don’t play well with some other brands, leading to constant disconnections.

What do you mean? I’m having no issues and as mentioned in my comment I have a lot of different brands together with 10 Aqara sensors.

Remember, they are a lot cheaper if you can wait a while and buy them from china (AliExpress)

I have positive feeling towards Aqara, but I have a mix of different brands:

• Plugs Blitzwolf (TuYa)
• Lights mostly Hue with one Osram (many of those were pre-homeassistant)
• Thermostats Lidl with one from Eurotronic
• Sensors: Motion sensors by Hue, everything else by Aqara (humidity/temperature and open/close)

Yeah, but that’s again a pure Hue thing, not related to ZHA, Z2M or anything. Competitor bulbs can be reset by turning them on and off in a pattern, Hue requires you to buy an extra device. If you don’t have one, I’m not sure how you managed to add them to Z2M at all?

I might use Porcupine, as I did when I tested Rhasspy. But one thing to think about, the easier it is to mishear, the more false positives you will have. Part of the reason I like porcupine, it’s a very distinct word.

Resetting bulbs is a hue feature, that doesn’t even require a hub at all. They should blink once reset and then, for me, they always joined Z2M right away.

Also, the need for an mqtt broker was not intuitive

Yeah, I guess that can be weird, I had one anyway for other stuff ;)

android app

https://hueessentials.com/

It even works with Deconz, but not ZHA or Z2M

The important thing is the main server, that’s the advantage of satellites.

Now I haven’t tried it yet, but with Rhasspy, you had the choice between the satellite doing wakeword recognition (which means that a pi zero 1 would be too slow), or doing it on the server (which would mean permanently sending all audio the satellite picks up to the server, and the extra latency that adds)

A pi3 is really powerful enough for wakeword recognition

I have not yet set it up (though I did test it for a bit, and recognition was great), but used PlayStation Eye webcams (I might now have 5 of those in my drawer :D) apparently have amazing microphones, so if looks are not as important, you’d just need to add speakers.

Why would their experience be relevant?

Partially, because experience in an area means one can understand the answer, but to a probably bigger part see below.

You could be nicer about it.

It read to me like they asked as if they know better than everyone else, and were ranting about others doing it wrong. But that was actually an assumption on my part, and may simply be their style, or even me completely misreading things. So thanks for calling me out on it.

(Relational) Databases can be in-memory. And unless you have very little data, your in-memory storage will probably turn into a database, and if it’s relational it might even turn into a pseudo-relational one. Just without all the benefits of 1000 of dev-hours of optimization. But next, you also need to persist your data. And you probably don’t want to lose everything if your app crashes. More stuff that is already done for you, if you use a non-memory database that probably will hold all frequently accessed data in memory anyway. And there are many, many more issues like that.

edited to be friendlier, original was

Relational Databases can be in-memory? This question sounds a bit like you have little to no experience with data or databases.

• Large files or no formatting required: EmEditor (Windows only, proprietary, expensive, but fast :D)
• Formatting some file: VsCode
• SqlLite queries over CSVs: Notepad++