Domoticz

Posted: **Thursday 10 January 2019 12:49**

Dear all,
I have domoticz 4.97 running on raspberrypi connected with daenetip4 denkovi board.
I started to use the new hardware set for the board "Denkovi Modules with LAN (HTTP) Interface" as suggested on Denkovi website.
With this feature is possible to refresh state of input/output with a setted refresh time.

The problem is that if a swicth is on and the refresh is again on an entry in the database is performed and in this way the database become very big and hard to be manage. At the moment I have an update every 10 seconds also if the status does not change.

How can I solve this issue? From my point of view an entry on the database must be done only if the state is differente than the previous.

????

Posted: **Thursday 10 January 2019 20:16**

I have the same problem with PIR devices filling up the database. I use an SQL commend to clear all entries except the last day like:

Code: Select all

#!/bin/bash

DAYS=1

/usr/bin/sqlite3 /home/pi/domoticz/domoticz.db "DELETE FROM lightinglog WHERE DeviceRowID IN (88,113,114,129) AND Date <= datetime(  'now', '-$DAYS day' );"

Domoticz

denkovi smartden IP

denkovi smartden IP

Re: denkovi smartden IP