{"id":15146,"date":"2026-01-19T23:44:20","date_gmt":"2026-01-20T07:44:20","guid":{"rendered":"https:\/\/www.apolonio.com\/blog\/?p=15146"},"modified":"2026-01-19T23:44:20","modified_gmt":"2026-01-20T07:44:20","slug":"getting-info-from-ha-to-mysql","status":"publish","type":"post","link":"https:\/\/www.apolonio.com\/blog\/?p=15146","title":{"rendered":"Getting Info From HA to Mysql"},"content":{"rendered":"\n<p>There is a variable in my Home Assistant that is considered when turning the lights on or off automatically.  I call them light hold values.  If say the kitchen hold is on, then the motion sensors will not turn the lights on or off.<\/p>\n\n\n\n<p>There is a button in the kitchen to toggle this value, but most don&#8217;t have access to the app.  So I created a web page that talks to a mysql database, and also updates it if needed.  So they just need a simple browser to look at a simple unauthenticated page, to see if the hold is on.<\/p>\n\n\n\n<p>Another tech thing I did today was install Windows 11 on a cheap HP TC630 thin client.  Had to do some hardware tricks but it is running windows 11.<\/p>\n\n\n\n<p>Weight: 327.0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is a variable in my Home Assistant that is considered when turning the lights on or off automatically. I call them light hold values. If say the kitchen hold is on, then the motion sensors will not turn the &hellip; <a href=\"https:\/\/www.apolonio.com\/blog\/?p=15146\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,14,11,3,9],"tags":[],"class_list":["post-15146","post","type-post","status-publish","format-standard","hentry","category-coding","category-new-toys","category-technical","category-training","category-weighin"],"_links":{"self":[{"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/15146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15146"}],"version-history":[{"count":1,"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/15146\/revisions"}],"predecessor-version":[{"id":15147,"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/15146\/revisions\/15147"}],"wp:attachment":[{"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apolonio.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}