for my project I need to be able to go back in time and access a small set of previously collected senor data values.
The set is quite small, about 10 - 25 values,
The values are collected over a period of the last 10 days from now.
The important value for my event/flow is the minimum in the set, which also needs to be persited/survive a restart of the flow/NodeRED.
What I have in mind is to collect the values in a rolling buffer and - when needed - access the bufffered values, calculate the min-value and store it/persist it then as well.
Would you recommend to deploy a database based node or store this in an array or key-value pairs to a local file or what else?
Thanks in advance for your input!