I am storing time series data arriving from a sensor into (time,value)
records, like so:
10:32 12
10:35 15
10:37 15
10:39 13
10:43 13
10:46 18
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
On Tue, Feb 25, 2020 at 1:03 PM John McKown
wrote:
> > I am storing time series data arriving from a sensor into (time,value)
> > records, like so:
> > 10:32 12
> > 10:35 15
> > 10:37 15
> > 10:39 13
> > 10:43 13
> > 10:46 18
> >
> > and I want to avoid storing repetitive data, so that the
On Tue, Feb 25, 2020 at 1:18 PM Keith Medcalf wrote:
> create table data
> (
> keytext primary key,
> data integer not null
> )
> without rowid;
>
> -- insert into data select (?, ? as value where value IS NOT (select data
> from (select max(key), data from data));
>..
>
rigger can't prevent the subsequent insert.
>
>
> -Original Message-
> From: sqlite-users On Behalf
> Of Przemek Klosowski
> Sent: Tuesday, February 25, 2020 12:02 PM
> To: SQLite mailing list
> Subject: [sqlite] Fwd: inserting new data only
>
> I am storing time serie
On Wed, Feb 26, 2020 at 11:56 AM James K. Lowden
wrote:
> > and I want to avoid storing repetitive data, so that the database
> > should contain
> > [...]
> > only the earliest time with the unchanging value is stored.
>
> Be careful what you wish for. Usually "avoid storing" is a proxy for
>
5 matches
Mail list logo
