Currently I'm logging data to an online MySQL database because the Pi is hooked up to the internet and I don't want to mess up it's SD with all the writes. I guess I will use SQLite like you when I'll install the Pi on the boat.
I'm with you on Grafana it's just a little bit too heavy for the cute RPi.
If the default plots of the node-red dashboard aren't good enough I would look up some javascript graphing libraries. There must be a way to implement this charts via the template node into the node-red dashboard. It might be helpful to get some insights on AngularJS which is used by the dashboard. If that's to complicated you can just use php to get the data out of the db in form of json and build your own little dashboard with a nice javascript plotting library.
I can't recommend you a specific library but I've used several without any problems. If you google it there are tons of sites with the X best libraries. You just need to try which one suits you best especially with your lets say fundamental programming skills
I don't know much about PHP plotting because online everyone would prefer javascript nowadays. Python has some mighty plotting libraries like matplotlib which I have used successfully some times but in the end python and I are not getting along. So if there is an alternative I personally would always use another path
Edit: a link on how to implement third party plotting libraries in node-red http://noderedguide.com/tutorial-node-re...al-charts/
I'm with you on Grafana it's just a little bit too heavy for the cute RPi.
If the default plots of the node-red dashboard aren't good enough I would look up some javascript graphing libraries. There must be a way to implement this charts via the template node into the node-red dashboard. It might be helpful to get some insights on AngularJS which is used by the dashboard. If that's to complicated you can just use php to get the data out of the db in form of json and build your own little dashboard with a nice javascript plotting library.
I can't recommend you a specific library but I've used several without any problems. If you google it there are tons of sites with the X best libraries. You just need to try which one suits you best especially with your lets say fundamental programming skills
I don't know much about PHP plotting because online everyone would prefer javascript nowadays. Python has some mighty plotting libraries like matplotlib which I have used successfully some times but in the end python and I are not getting along. So if there is an alternative I personally would always use another path
Edit: a link on how to implement third party plotting libraries in node-red http://noderedguide.com/tutorial-node-re...al-charts/