Write to database

Hi, my database began to grow and I could see it wrotes a new row on each change of an entity, not only in when their state changes, if any property changes it would write a new line.

So I have some shelly switches and using ShellyForHASS, enabling getting more info, it updates wifi quality or temperature than can change a lot. All this change wrote a new line and I would like to avoid it. For the moment I disable to update this attributes but I would like to read some of them.

Is there any configuration to excludy this behaviour?

Check out the recorder’s whitelist/blacklist functionality. Next to that, also check out the Filter integration and its throttle capabilities.

I have a weather station that updates data every 12seconds, I throttle that and only record data every 10minutes.

1 Like

I use whitelist for recorder, I want to record the light status but not all their attrs, is it possible?

Use a template sensor for that and put the template sensor in the whitelist.

Thanks, but would like to found a more generally alternative, because I have about 40 light entities… I wouldn’t like to create 40 new sensors

There is no general alternative. It’s all or nothing with each device.

Thanks, I’ll try to modify the component to not write too many attrs in first isntance

If you know how to code, why not make a change to the integration that allows included entities to have a second attribute that gives users the ability to ignore all or specific attributes?