EFForg / starttls-backend

STARTTLS Everywhere web backend and checker
https://starttls-everywhere.org/
Other
18 stars 6 forks source link

Simplify query for 14-day averages of user-initiated scans #235

Closed vbrown608 closed 5 years ago

vbrown608 commented 5 years ago

Currently, we have a big postgres query that generates averages over a rolling window. It was fun to write, but it's very complex. Instead, we could run a daily task to calculate and store an average for the past 14 days.