Write to database

Configuration
1

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?

2

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
3

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

4

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

5

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

6

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

7

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

8

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?