I am building a smart window fan, somewhat similar to this fellow’s: https://www.hackster.io/Granpino/smart-window-fan-4b077e.
I do not yet use HA, although I can see it in my future. I have written a crude python code to control the fan (turn on if it is cooler outside than in). It tracks both humidity and temperature inside and out, and calculates the dew point. There is a relay attached to turn on the fans. These are all connected to a raspberry pi zero w. Before I go in any deeper, I could see wanting to connect this with home assistant in the near future. For example, I would like to store the data connected, make a web page to look at plots, etc. I know nothing about databases. Before I make any decisions on how to do this, how do I save myself (and maybe others who want to adopt this as a plugin time in the future? Maybe I should just start integrating it now in HA? Maybe I should store data in sqlite?
Any and all comments and insights are welcome!