I would like to request an automatic database handover/switchover from the internal database to the external database (e.g. InfluxDB) whenever data is requested from e.g. a graph card that exceeds the tracking time in the internal DB.
By default, the internal database does not track all entities and it also cuts off the tracking after 14 days. It is not designed for long-term statistics and not for large amounts of data. Hence a lot of people are using databases such as InfluxDB, which are perfectly integrated into HA. Everything is easily stored there but it is difficult to get the information from there. None of the stock dashboard cards nor the custom cards can directly access this data (only possible with python code or similar, which is not suitable for beginners and bloats the code significantly).
In addition, the influxDB which holds data for weeks, months and years, can be easily restored and the data immediately becomes available again.
As the integration of InfluxDB into HA is so good anyway, I would like to request a seemless handover to the InfluxDB data once the tracking for an entity goes blank in the internal DB.
HA recognizes if an external DB is available so this feature will only work if a DB is available. If one is detected, then when data for a time is missing, automatic search in external DB is launched and reported to the requester.
This will be slightly slower than the internal DB, but it will make life a thousand fold simpler for most users and is fully in line with the current approach of making life easier to non-coders.
Thank you for your consideration.
EDIT: As I think there is a misunderstanding of my goal, please see further explanation in my following post
The goal is not to change or enhance the abilities of the internal database. The goal is to get Home Assistant to automatically re-route a query to the external database if it cannot find the information in the internal one.
There should be no changes to the internal database or its functionality.