[metrics-bugs] #24218 [Metrics/Statistics]: Implement new metrics-web module for IPv6 relay statistics

[Tor Bug Tracker & Wiki]

#24218: Implement new metrics-web module for IPv6 relay statistics
------------------------------------+--------------------------
     Reporter:  karsten             |      Owner:  metrics-team
         Type:  enhancement         |     Status:  new
     Priority:  Medium              |  Milestone:
    Component:  Metrics/Statistics  |    Version:
     Severity:  Normal              |   Keywords:
Actual Points:                      |  Parent ID:
       Points:                      |   Reviewer:
      Sponsor:                      |
------------------------------------+--------------------------
 The sample graphs I made for #23761 are based on some quick-and-dirty Java
 code that we need to rewrite in a more robust and more scalable way before
 putting these graphs on Tor Metrics.

 Here's my plan for implementing this module, and I'm curious to hear
 possible alternatives or improvements:

  - We start with a design quite similar to the recently added
 [https://gitweb.torproject.org/metrics-web.git/tree/modules/webstats
 webstats module]. This basically means creating:
    - a PostgreSQL database schema for import tables and aggregations/views
 and
    - a Java class to import into the database and run queries.

  - I believe that the data aggregation won't scale to years of data. My
 hope is that we can solve this in the database by using some triggers to
 only include newly added data in the aggregation.

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