On Tue, 25 Feb 2020 12:02:24 -0500 Przemek Klosowski <przemek.klosowski+sql...@gmail.com> wrote:
> and I want to avoid storing repetitive data, so that the database > should contain > 10:32 12 > 10:35 15 > 10:39 13 > 10:46 18 > where only the earliest time with the unchanging value is stored. Be careful what you wish for. Usually "avoid storing" is a proxy for some kind of intended use. Unless it's infeasible, it's usually better to store everything, verbatim, as it arrives. Then you can present it however you like, with nothing lost. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
