Building a smart home database has been an exciting journey for me. After two years of running OpenHAB and Node-RED, I decided to take the next step by creating a personal database. I started with MySQL, setting up both the server and client on my OpenHAB machine. While I have some knowledge of SQL, figuring out the right schema design was a bit challenging. I’ve been researching online, but finding the right approach has been tricky. If anyone has a working example or tips, I’d love to hear them!
Integrating devices is another area I’ve been exploring. For instance, I recently installed Govee RGBICW Cube Wall Sconces. They came with everything I needed, including the control panel and mounting brackets. Setting them up was straightforward, and they’ve added a nice touch to my home decor. I’ve also been experimenting with Wyze cameras, but I encountered a connection timeout issue during setup. It turned out to be related to my NTP redirect rule, which I had to disable temporarily. After setup, I re-enabled the rule, and it worked until a restart. It’s a bit puzzling, but I’m glad I found a workaround.
For those looking to expand their Zigbee network, I’ve heard great things about the SONOFF Zigbee 3.0 USB Dongle. I’m planning to use it alongside my existing Hue bridges to manage up to 205 devices on my Home Assistant system. It’s a lot, but with the right setup, I’m confident it’ll work smoothly.
Another interesting project I’ve been working on is enabling and disabling specific sensors for my alarm system. I want to create a board where I can toggle sensors on and off with the press of a button. It’s a bit technical, but I’m determined to figure it out.
Overall, building a smart home database and integrating various devices has been both challenging and rewarding. Each problem I solve brings me closer to my goal of a fully automated home. I’d love to hear about others’ experiences and tips!