At some point in time, I had entity A providing me with energy statistics for my solar panels. This entity was later replaced with entity B and entity A no longer exists. However, in the long term statistics database, the values are still logged under entity A and there’s no straightforward way to merge/rename them to Entity B.
This means that I have entity A still configured in my energy dashboard even though the entity is no longer reporting new data. Attempts at merging the data require running SQL queries directory on the (SQLlite or MariaDB) database. WTH isn’t there a better option?
but not ideal for sure.