For context, I’m trying to store data from multiple PLCs in InfluxDB and query this data. I have a two schemas in mind, which approach is better?
Measurement: plc_data
Tags:
name
tag_name (e.g., Temperature, Relative Humidity, Valve01Status)
data_type (e.g float, bool, int, string, etc)
Fields:
float_value
int_value
bool_value
string_value
================================
===== Or the following ones ====
Measurement: float
Tags:
name
tag_name (e.g., Temperature, Relative Humidity)
Fields:
value (e.g 45.6)
Measurement: bool
Tags:
name
tag_name (e.g., Valve01Status, Valve02Status)
Fields:
value (e.g 1 or 0)
If there is a different approach that is better feel free to let me know.
