[metrics-bugs] #27715 [Metrics/ExoneraTor]: support relative time in timestamp parameter

[Tor Bug Tracker & Wiki]

#27715: support relative time in timestamp parameter
--------------------------------+------------------------------
 Reporter:  exonerator          |          Owner:  metrics-team
     Type:  enhancement         |         Status:  new
 Priority:  Medium              |      Milestone:
Component:  Metrics/ExoneraTor  |        Version:
 Severity:  Normal              |     Resolution:
 Keywords:                      |  Actual Points:
Parent ID:                      |         Points:
 Reviewer:                      |        Sponsor:
--------------------------------+------------------------------

Comment (by karsten):

 Hmm, I see the use case, but I don't really like that the `timestamp`
 parameter accepts a date and a number.

 Here's a possible variation of your idea, which would cover even more use
 cases than yours: if the `timestamp` parameter is left empty, we return
 the most recent 3 days when the given IP address was seen in the Tor
 network. We could even include this in the web interface by making the
 date parameter optional and saying what we return if it's left empty.

 In theory, our new database schema should handle this query just fine. It
 should be just one more query in the `date_address24` table to learn the
 latest contained date for a given IP address prefix. That table is
 currently 1130 MB large with over 10 years of data.

 If this makes sense, we can put it on the list. Needs a patch and a fair
 amount of testing, so that we're not running into performance issues
 again.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/27715#comment:1>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online