How to limit update rate of local push sensors?

Configuration
1

Manage sensors’ update rate

Actual situation

Polling sensors

With polling sensors home assistant can limit the rate of polling using scan_interval

With Local push sensors

Local push sensors send data whenever they want. If the frequency of update is high, the system is flooded with updates that make the DB incredibly huge. High update frequency can also slow down the system and increase the cpu load.

Solution: scan Interval on local push = ignore some updates

If I ask why scan_interval is absent on local push sensors, people say that is not possibile to implement because home assistant behave passively and cannot stop sensors from sending the data.

  • Why home assistant doesn’t ignore sensor updates that falls out of scan interval?
  • Why I have to accept the fact that I can’t control how many states are written to a DB?

Examples

  1. Mqtt sensors: I have a meteo station connected using mqtt sensor and the update rate is about 1 update every 30 seconds!!! My DB is suffering as you can imagine
  2. Ble sensors: Using ble sensors the sensor sends data to home assistant every minute and also in this case I have to record all the data because I cannot ignore updates

7000 updates in 1 hour, it’s a crazy amount of messages

image