The ESPHome device I have (it’s a scale) sends an update at a regular interval, and that update is written to the MySQL database for HA. As expected, it writes zero values all day long, and I’d prefer to only write the values if there’s activity on that scale, so we only have actual measurements and not a spammed database of nothings.
Is there a way, outside of the ESPHome configuration for that device, to trigger “recording” of historical information to MySQL upon demand?
I could probably use NodeRED tied to MySQL to create a new database with just this information, but the more doo dads I create, the more there is to manage. Integrating it into the default recorder setup would be nicer to keep the database centralized.
Any ideas?