search

lun-4 / awtfdb

the Anime Woman's Tagged File Data Base.
MIT License
36 stars 2 forks source link

metrics/analytics gatherer #30

Closed lun-4 closed 2 years ago

lun-4 commented 2 years ago

create a separate program that runs as something that you configure via cron so that, say, every 5 am, run some analytical queries on the database (say, amount of files, amount of tags, things ilke that), so that we can generate pretty graphs

not sure if the result of those metrics should be in the awtfdb database itself or should it live as a separate project...

lun-4 commented 2 years ago

here's my decision: it should be in the database itself and specified for consumption by other tools.

when creating metrics like "files over time", use the 0th migration's timestamp as the "0 count" source, so databases that are migrating to get the metrics (like mine) have at least 2 datapoints to build from.