Hello everyone,
I am looking to clean up some old data from my home assistant database (SQLite).
Looking more closely at the data itself I noticed something surprising to me:
It is always said that values that remain constant are not written to the database and hence do not increase the db size.
But, everytime the sensor is updated, irrespective of whether or not the value changes, an entry is written to the db.
E.g. in states an entry with last_changed_ts NULL is created. So the same amount of rows are created whether or not the value of a sensor changes. So (almost) the same amount of data is written to the database.
Am I missing something or was the information incorrect?
Should the database not be blind to updates the system receives if there is no change in value?