Re: [sqlite] inserting new data only

2020-02-26 Thread Simon Slavin
On 26 Feb 2020, at 5:18pm, Przemek Klosowski wrote: > This 'store only changed values' is > intended for situations like that. > Another suitable candidate for that treatment might be a status, for > instance 'on battery' value for a UPS monitoring system. I can't think of a > scenario where

Re: [sqlite] inserting new data only

2020-02-25 Thread Simon Slavin
This strikes me as best solved in the programming language. If a single set of data points is being acquired in real time, and you have a programming language (or script) generating the INSERT commands, why not simply keep the most recently inserted temperature in a variable ? On the other