[tor-bugs] #15844 [Onionoo]: Develop database schema to support Onionoo's search parameter efficiently

[Tor Bug Tracker & Wiki]

#15844: Develop database schema to support Onionoo's search parameter efficiently
-----------------------------+-----------------
     Reporter:  karsten      |      Owner:
         Type:  enhancement  |     Status:  new
     Priority:  normal       |  Milestone:
    Component:  Onionoo      |    Version:
   Resolution:               |   Keywords:
Actual Points:               |  Parent ID:
       Points:               |
-----------------------------+-----------------

Comment (by leeroy):

 > [..] However, should we save this problem for later?

 Allow me to clarify. The test Onionoo described is only modified to fit
 both the PostgreSQL and Onionoo test servers to the same aws-server, and
 enforce a proxy on Onionoo. It will use only the first update (roughly
 half the data), and without cron updater. Not with any particular
 improvements. I just wanted to point out PostgreSQL has JSON serialization
 built-in, so once the comparison begins, and granted favorable prior
 results, it would be worth checking this out.

 If anyone else wants to post table designs for testing I could simplify
 the update code of Onionoo for use with a database. When that time arises,
 that is.

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