I have a small plastic hobby greenhouse in my backyard (its big for my backyard) that I grow veggies, herbs and leafy greens in. Generally I do these in batches at 1 month intervals. (no not those sort of herbacious veggies - REAL VEGETABLES AND KITCHEN HERBS)
My greenhouse lights and simple irrigation system is controlled by HA (zigbee plugs)
Id love to be able to log what Ive done to each plant/batch over time. I currently have an automation that casts my work/family calendar todo list and things like stock/crypto prices as well as todays weather on my 75" TV first thing in the morning and would love to cast some sort of “greenhouse status” as well telling me what was done and when and perhaps show what sort of cycle the plants are in.
I know this is not exactly the “use case” for HA but I was thinking that the diversity of what ppl are using it for, why shouldnt I see if I can do something cool with it for my gardening??
The question is: Whats the best way of logging non entity data with the ability to retrieve it thru HA (somehow) so that I can cast it AND would MariaDB the db of choice??
Essentially I want to do the following (take for instance a csv: header rows)
plant, batchno, germination date, pot no, plant date, plot no, fertilized date, water date, harvest date
tomato, t001, 29/02/2023, p001, , , , , ,
tomato, t001, , , 17/03/23, gh008, 17/03/23, 17/03/2023, ,
Essentially log data based on the batch no based on what I do in the greenhouse and then be able to recall it and show it on something like a dashboard (I havent thought this all the way thru yet)
Hope some kind soul may have a “rough idea” as to how I can get a seed and grow this idea