Yes, I have edited data to have a power consumption in indicated date. You
are very precise (observant), BTW :D
On Thu, Aug 8, 2019 at 12:10 PM Jean-Christophe Deschamps
wrote:
>
> Oops, didn't notice the date of said row was out of sequence wrt rowids.
>
>
An ID is just an ID. Unique mark in the row. No other meaning.
So sanitizing not necessary, AFIK.
On Thu, Aug 8, 2019 at 11:59 AM Jean-Christophe Deschamps
wrote:
> Beware that row id 6655 isn't correct (total_kwh is suddenly decreasing).
> This inconsistancy maybe related to row 6654 missing:
Oops, didn't notice the date of said row was out of sequence wrt rowids.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Beware that row id 6655 isn't correct (total_kwh is suddenly decreasing).
This inconsistancy maybe related to row 6654 missing: manipulated data?
So you'd have to sanitize your data first.
ID TIMESTAMP TOTAL_KWH
66532019-08-06 22:23:26.000 1494.00
66552019-07-30 22:32:26.000
enough mesurements, you could do a fourier
> analysis to quantify daily/weekly/yearly variations and a "base load"
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> Im Auftrag von Petr Jakeš
> Gesendet: Donner
Auftrag von Petr Jakeš
Gesendet: Donnerstag, 08. August 2019 09:36
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] select for power-meter accumulated total readings
I am storing electricity consumption data to the sqlite.
The simple table to store kWh consumption looks like f
6 matches
Mail list logo