Another question
So with the default configuration, pimatic checks every 2h the database for expired entries and deletes them (in memory) and each second time (every 4h) the changes are synced to disk (deleted and new entries).
I have the impression that nothing is written in the DB anymore, for testing purpose i have reduce deleteExpiredInterval and diskSyncInterval to 1 minute and 3 minutes
"database": {
"client": "sqlite3",
"connection": {
"filename": "pimatic-database.sqlite"
},
"deviceAttributeLogging": [
{
"deviceId": "*",
"attributeName": "*",
"expire": "7d",
"type": "*"
},
{
"deviceId": "pin-switch",
"attributeName": "*",
"expire": "0",
"type": "*"
},
{
"attributeName": "contact",
"expire": "31d",
"type": "*"
},
{
"deviceId": "rasptime",
"attributeName": "uptime",
"expire": "0",
"type": "*"
},
{
"deviceId": "syssensor",
"attributeName": "*",
"interval": "5m",
"expire": "7d",
"type": "*"
},
{
"deviceId": "*",
"attributeName": "temperature",
"interval": "5m",
"expire": "1y",
"type": "*"
},
{
"deviceId": "*",
"attributeName": "humidity",
"interval": "5m",
"expire": "1y",
"type": "*"
},
{
"deviceId": "gas-sensor",
"attributeName": "*",
"interval": "10m",
"expire": "31d",
"type": "*"
},
{
"deviceId": "conso-gaz-24h",
"attributeName": "*",
"interval": "1h",
"expire": "1y",
"type": "*"
},
{
"deviceId": "elec-sensor",
"attributeName": "*",
"interval": "10m",
"expire": "31d",
"type": "*"
},
{
"deviceId": "conso-elec-24h",
"attributeName": "*",
"interval": "1h",
"expire": "1y",
"type": "*"
}
],
"messageLogging": [
{
"level": "*",
"tags": [],
"expire": "7d"
},
{
"level": "debug",
"tags": [],
"expire": "0"
}
],
"deleteExpiredInterval": "1m",
"diskSyncInterval": "3m",
"debug": true
},
I can’t see any message in pimatic log about the DB sync and nothing on the timestamp of the DB : so my impression is that nothing will go to disk (pimatic-database.sqlite-wal remains empty too)