View Single Post
Old 31st January 2020, 00:33     #10
Lightspeed
 
blynk has a "history table", or a chronologically ordered list.

Basically they want to record the first row, then exclude any subsequent row that matches all columns in this row with the exception of the "update_date" column, recording the next row that does not match all columns (i.e. a genuine update), and so on.

I think it can be done, but I'm too lazy to think through the nested structures to figure it out.
__________________
Stay shook. No sook.
  Reply With Quote