[sqlite] Powershell Enter-PSSession for sqlite3.exe fails

I can run sqlite3.exe on a remote server with a remote desktop connection but when I try using Enter-PSSession, using the same credentials, the sqlite3.exe gives no output and no exitcode. However, if I use the -version option it dutifully reports the version. I have tried search engines, but

Re: [sqlite] [EXTERNAL] select for power-meter accumulated total readings

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. > >

Re: [sqlite] [EXTERNAL] select for power-meter accumulated total readings

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:

Re: [sqlite] [EXTERNAL] select for power-meter accumulated total readings

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

Re: [sqlite] [EXTERNAL] select for power-meter accumulated total readings

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

Re: [sqlite] [EXTERNAL] select for power-meter accumulated total readings

Thank you. To make thing easier I would expect linear extrapolation between missing dates. So fare I have written this SELECT (example data included) (I am not sure how to format the code properly here

Re: [sqlite] [EXTERNAL] select for power-meter accumulated total readings

I see two subproblems in this query a) estimating total electricity consumption for points in time that do not have an entry b) generating regular points in time ad a) assume a linear consumption of power between two measurements So for a time tx that is between ta and tb with values of pa and

Re: [sqlite] [EXTERNAL] Re: Problem with int and DateTime types with EntityFrameWorkCore.Sqlite

There is no decimal type in SQLite, and you are lucky that they are converted to string instead of real, because you cannot do proper (implied) decimal (point) arithmetic with real (ieee binary floating point) values. The rounding errors intruduced by binary floating point not beeing able to

[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 following example (accumulated total readings in each row - exactly as you see on your electricity meter): |ID|timestamp|kWh ||1 | 2019-07-31 14:24:25 | 270.8||2 |