I've been experimenting heavily over the past week with script columns that support caching. I strongly believe the next step for these columns would be to have this feature. Of the two viable options I see (ADS and databases), IMHO databases are the clear winner. There are some quirks and minor issues, but I'm guessing that with more users giving it a try, those could be worked out.
However, the main issue is accessibility, since it depends on a third-party setup. Meaning, to use this feature, the user would need something already installed (like Office or the SQLite COM wrapper).
I know this is terrible niche, but just like when I suggested support for making HTTP requests directly from Opus, I’ll give it a shot:
Does it make sense for Opus to provide API support for handling databases via SQLite? This could open up a ton of possibilities beyond just caching data for columns.
Thanks for considering it!