General expiry on the default database SQL cache

[enyciaa]

Use case

The MemoryCache has a field expireAfterMillis. This feature would also be useful for the sql cache.

Describe the solution you'd like

An expireAfterMillis field when creating the SqlNormalizedCacheFactory.

If there's no plans to add this to the library, it'd also be great to hear, or indeed if there is an api for this that I've missed!

[martinbonnin]

Hi 👋 Indeed, that's a current limitation of the SQL cache. We do have plans to improve that situation albeit it's a complicated problem. You can read some of it in this issue. There are also incubating artifacts with TTL/expiration APIs to support this albeit I wouldn't use them in production at the moment because I'm not sure how performant they are. If you end up trying them, please let us know what you think of the APIs as we're in a place where we can still change them and feedback is very welcome.

[enyciaa]

Awesome that it's in the pipeline! Will close this issue with reference to that one #2331