I'm new to InfluxDB, but it seems to me there's a bit of a conflict between Node-RED/MQTT's messaging structure and InfluxDB's "measurement" concept in that the former wants to be atomic while the latter expects multiple (related) values in the same message. Take as an example, some basic system par…

While I am not a professional InfluxDB consultant, my own assessment is that your approach is fine and it is the one I've been using for a few years without worrying about it. Indeed, it would appear (though I've not explicitly tested) that if you reduce the precision of the timestamp, you are more…

No, this is common for a timeseries db, some of my tables are far more sparse. It doesn't really matter since you will generally be summarising by a timespan (GROUP BY time()) so everything comes out nicely.

The alternative, as far as I can tell, would be to have one "measurement" (table) for each parameter. Then every table would be 100% populated, and no rows would contain any gaps. But that's probably a bad idea? Edit: Sorry @cymplecy , but I can't see myself going down that route; too fiddly and fra…

You've not understood my suggestion :slight_smile: I'm saying write all the fields when you receive an update on any of them

For this kind of data you could take a look at telegraf: https://www.influxdata.com/time-series-platform/telegraf/

I have always assumed that since this is exactly the sort of data that influx is intended for that it is optimised to minimise such overheads.

[image] cymplecy: You've not understood my suggestion :slight_smile: I'm saying write all the fields when you receive an update on any of them Ah, that makes a lot more sense, thank you! Still not sure I like it though... The way I see it, an event is a change, and that's all you should need…

[image] Colin: I have always assumed that since this is exactly the sort of data that influx is intended for that it is optimised to minimise such overheads. Yes, but that doesn't mean there aren't more or less efficient ways to design your schema... For example, I have no need for ms precisi…

Your sentinel/system/ messages are all arriving at the same time. If you subscribed to sentinel/system/# and fed the results into a join node set to wait for 6 messages and put them in an array you could insert them all at once. No database redundancy (null fields).

[image] ghayne: Your sentinel/system/ messages are all arriving at the same time. Well spotted! Unfortunately the timestamps are misleading in my example; they are the same because I manually triggered a read of all values, just to see how it would look in the DB. I considered editing my samp…

[image] ghayne: f you subscribed to sentinel/system/# and fed the results into a join node set to wait for 6 messages and put them in an array you could insert them all at once Or to cope with the fact that some may be missing set the join node to send after 30 seconds (or whatever) so that i…

Node-RED

Node-RED Forum

Confused about MQTT > InfluxDB

General

clickworkorange 6 October 2019 15:06 9

Ah, that makes a lot more sense, thank you! Still not sure I like it though... The way I see it, an event is a change, and that's all you should need to store...

Topic		Replies	Views
Data entry into influxdb General database	22	2405	8 February 2022
Help needed with MQTT to influx General	23	4215	11 May 2020
Advice for structuring data for MQTT and InfluxDB General	8	947	23 December 2021
Mqtt - node-red - influxdb General	24	3181	23 November 2020
Multiple topics to one influxdb mesurement General database , function-node , mqtt	13	386	27 August 2023

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.

Confused about MQTT > InfluxDB

Related topics