I'm building a dashboard for a News Site and one of the asks is to display the date/time of the last fetch that actually hit the CMS / db for certain URLs.

We're using directus and sqlite headless and on Next 13.5.2

We're caching things with a week long revalidation but want to be able to manually trigger a revalidation when necessary. News articles often get edited multiple times in the first few days and the goal is to be able to manually clear the cache in those instances.

Been searching to no avail. Feels like there should be a way to determine when the last time a request actually hit the db but can't seem to find a lead.

Any help would be greatly appreciated.