Implement a bulk-queryable cache of latest visits for use by the recurrent visit scheduler
To implement its scheduling policy, the recurrent visit scheduler needs to be able, fairly quickly, to get a list of origins and their latest visits present in the archive.
We also need to store more information, e.g. how long ago the last eventful visit was, whether the last run failed (and if so, for how long tasks have been failing), etc.
This cache needs two components: a database and associated API, and a journal client we can use to update it.
pad: https://hedgedoc.softwareheritage.org/DURdfOGyQomXEwbyFaS4gg?edit
Migrated from T2443 (view on Phabricator)
Edited by Phabricator Migration user