denkovi smartden IP

Others (MiLight, Hue, Toon etc...)

Moderator: leecollings

Post Reply
diegoflyer
Posts: 8
Joined: Wednesday 31 January 2018 13:39
Target OS: Raspberry Pi / ODroid
Domoticz version: 2023.1
Location: IT
Contact:

denkovi smartden IP

Post by diegoflyer »

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.

????
Raspberry Pi 3b+ - Domoticz 2023.1
NodeRED
Solaredge inverter
SweetPants

Re: denkovi smartden IP

Post by SweetPants »

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' );"
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest