Hi, I have several temperature sensors sending data to gauges on a dashboard, the data is put into a variable in a function node, what i want to do is write a file automatically at the right time of the month with all the temperatures on it, would this be easy to do ? any help appreciated. Thanks Stuart

Thanks I will have a read in a bit Stuart

[image] TotallyInformation: It is far easier and more resource efficient to use InfluxDB (or a similar Time Series DB) for this. Hmm it may well be more efficient but I'd argue with the far easier bit. While SQL databases are hardly straightforward, at least the INSERT SELECT & DELETE queries are logical. I find Influx distinctly odd with it's measurements and buckets.

Hi Jbudd, I am just looking at options really, I work for a charity and so I am classed as commercial I suppose so not looking to buy any licenses, Is the SQL database free to use ? Thanks Stuart

There is a fully Open Source version of InfluxDB so you will be fine if you want to use that.

Thanks I will have a look at all this later when I get home Stuart

[image] jbudd: I find Influx distinctly odd with it's measurements and buckets. It takes a few minutes to work out. :slight_smile: That's why I wrote the article. Done once and forgotten about until needed - which is pretty much never. The important part is that you don't have to worry about getting aggregations right, a very simple query gives you aggregations over time periods. And if you use Grafana, it is even easier.

[image] How to effectively use InfluxDB FAQs An InfluxDB measurement is similar to an SQL database table. InfluxDB tags are like indexed columns in an SQL database. InfluxDB fields are like unindexed columns in an SQL database. InfluxDB points are similar to SQL rows. So I have a database called domotica with the following measurements: [image] The environment measurement contains all of my sensor data I have a couple of tags: location and type Location tags are real places such as "Kitchen" type tags are sensor measurement types su…

Thanks for the info, I might set it up on my own computer at home first and see if I can get my head round it lol Stuart

I see you are leaning towards Influx and it's a perfectly sound choice. [image] acestu: Is the SQL database free to use ? A quote from sqlite.org: The core SQLite database software is in the public domain. No license is necessary to use SQLite or to build SQLite into your products.

Hi, They both look a little over the top for what i need, I think I need to get my head around variables first and find out how they work in node-red, I have variables in my function flows and was told if I go to context data in the menu that the current values of the variables would be displayed but it shows nothing so I will have to post about that. Thanks Stuart

Node-RED

Node-RED Forum

Write a monthly temperatures File

General

TotallyInformation 28 May 2025 15:22 14

Topic		Replies	Views
Read messages from a file and process time-based General	11	884	19 October 2020
How to effectively use InfluxDB FAQs database	22	3303	14 January 2021
Automatically write sensor data to new folder after midnight General	4	299	28 April 2021
Create a Node-Red Datalogging General	4	537	9 March 2021
Helpful criticism requested General	44	2765	17 July 2018

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Write a monthly temperatures File

Related topics