Problematic usage of the EntityLookupCache in app runner

[leoschwarz]

The concept of caching there should be revisited. The problem is that entities remain cached after being updated. Fixing this properly would be too much implementation effort as it would require creating a full ORM.

My new favorite for the caching api is the follows:

• Cache by default caches no entities.
• Each entity type can be registered to be cached. Two options are possible:
  • In memory
  • In file
• This configuration is available as a pydantic model and can be configured from yaml.
• Unclear: Retention time to be defined