Indigo Domotics

Mine update correctly

Not all variables update all the time. Ie thisdaymax changes only when a new max happens today.

Naturally it is your choice to use this plugin

Karl
Sent from my iPhone using Tapatalk

I found that my sql logger plugin was not enabled, once enabled all applicable data populated, that was apparently the problem. Is there any way to edit values in the log? I have goofy value in a variable that I would like to correct if possible; e.g. "xxx_value_thisDay_Max" has value of 143.5, it is a temperature and should be 43.5, don't know why it recorded 143.5.

Thanks,

Billy

you could use an sql tool to edit the db, there is nothing from teh indigo side. indigo just added new entries and has the option to purge old data

So you could purge device(s)

indigo by default only does all devices before xx and all variables before xx..

utilities plugin has an option to purge ONE device/ variable .. as I recall


Karl

... And the min max plugin has the option to ignore values outside a range.
Set the range at the bottom of the selection screen


Sent from my iPhone using Tapatalk

I am experimenting with an editor. I found & made a copy of what I believe is the correct database "indigo_history.sqlite". I imported it into the editor & can see the definition of db structure including the Indigo item number I want to edit, but I see no actual data records in this file. Does the logged data reside in another file?

Billy

If you don’t know what you are doing = doing this the first time - I strongly suggest to not mess around with the sql dB.

And may I suggest to switch from SQLite to Postgres dB

Installation is very simple

1 download Postgres app
2 install = double click on downloaded app
3 in indigo switch from SQLite to Postgres in sqllogger ( and in minmax plugin )

Postgres is much more stable than SQLite, faster and ...
SQLite is just one file, any issue will render your dB corrupt will just grow - difficult to compress


Sent from my iPhone using Tapatalk

Tried switching to postgreSQL, but something not right,all data links are severed. The min/Max config snapshot is in two captures due to file size limit. Any suggestions?

in config try:
/Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres

instead of
/Library/PostgreSQL/bin/psql indigo_history postgres

that is the path to the postgres binary in the app

the plugin need to know where to find postgres.

Karl

The directory structure not even close...

To try it open terminal
And paste the path and hit enter
Only the psql part when you get a prompt eg #
you are right


Sent from my iPhone using Tapatalk

....And the app is actually a directory. You need to right click on the psql.app and select contents. And go down until you find psql.bin (likely that’s the name)


Sent from my iPhone using Tapatalk

"SQL Shell (psql).app" is the closest thing I could find, I drill down into all sub folders and did find "psql.bin". I also did finder search for "psql.bin" and results were empty.

Mine is still at v10.
I will download the latest tomorrow and check.


Sent from my iPhone using Tapatalk

/Applications/Postgres.app/Contents/Versions/latest/bin/psql
is mine for v 13

did you download from here?
https://github.com/PostgresApp/Postgres ... 4.1-13.dmg

Karl

I removed previous postgres install and re-installed from the link you provided. Directories line with with your directions now, but I am still not getting data from db. I didn't see any similar path setup in SQL Logger config, I think perhaps the SQL Logger is not doing what it needs to.

Billy