openverse-api icon indicating copy to clipboard operation
openverse-api copied to clipboard

"updated_at" or "refreshed_at" column for providers

Open zackkrida opened this issue 3 years ago • 2 comments

It would be cool to have a 'last updated' column on the sources page that showed when a provider last had new images added to the API.

Currently this might not be super useful, if all provider scripts run in every refresh and the date would be the same for each one. I can't remember exactly how that is working.

zackkrida avatar May 24 '22 01:05 zackkrida

Commenting in support of refreshed_at or more specifically against updated_at. updated_at I see used as the de facto column name for when a row is updated and it'd be easy to confuse the timestamps semantically. refreshed_at or reingested_at (and maybe even an initial_ingestion_at) column would all be clearer, semantically, I think.

sarayourfriend avatar May 24 '22 05:05 sarayourfriend

I think it would be useful! We have some providers (looking at you Flickr) that we still haven't got up and running whereas we update others regularly. +1 to refreshed_at specifically

AetherUnbound avatar May 27 '22 03:05 AetherUnbound