Until discovering OMG i have been connecting to and querying my miflora and mija ble sensors individually, the one benefit of this is the retrieval of a complete data record which lends itself to the construction of a simple sql insert statement into a basic Miflora or Mija table containing all the relevant data fields for the respective sensor readings.
Now using OMG to retrieve the data from the publicly advertised data from the sensors a am getting payloads of a single sensor reading rather than a full data set.
I could just carry on with a minor node red function edit to use null as a default data element when constructing the sql or each insertion but that will result in sparsely populated tables which i do recall as being a big nono. I could go full boyce codd and end up with multiple sensor tables keyed by parent device id and a timestamp.
Or i could just start using a time series db??
Before i plunge into yet another new(to me) tech i thought it wise to ask here if there is a best practice trick for buffering data for sql inserts or should i just get on and RTFM… thanks…