I have at home some ready-made sensors I bought and more custom ones will come, therefore I would like to collect all their data and to set rules/actions based on them.
I looked into the various alternatives but, after discovering Node RED, it's not clear to me anymore which overlap there is between OpenHAB, Home assistant and Node RED in regard to data acquisition, storage, display and processing (rules).
Initially I checked Home assistant and I saw that it can
- collect data with plugins/addons
- store it in its own database (round-robin, time-limited)
- store it ("persistence") on external databases
- process data (YAML rules/automations), from what I understand using data in its own database when knowledge of the previous values is required
- display data (web GUI)
From what I understood, OpenHAB 2 does 1, 3, 4bis, 5: it uses the external database ("persistence") also for rules. It appears therefore it is conceptually more efficient, one database is skipped.
I thought that Node RED was just a "graphical rule editor/processor" compatible with both previous alternatives, but now I discovered that it can do at least 1, 3, 4bis: collect data via a (quite limited) number of input plugins, store the values into an external database, perform rules querying said external database.
At this point, is there any remaining difference between Node RED and the other two? What are the conceptual differences and similarities between OpenHAB, Home Assistant and Node RED?