[tor-bugs] #13578 [BridgeDB]: Store Pluggable Transport information in database

[Tor Bug Tracker & Wiki]

#13578: Store Pluggable Transport information in database
-------------------------+----------------------
 Reporter:  sysrqb       |          Owner:  isis
     Type:  enhancement  |         Status:  new
 Priority:  blocker      |      Milestone:
Component:  BridgeDB     |        Version:
 Keywords:               |  Actual Points:
Parent ID:               |         Points:
-------------------------+----------------------
 We currently save a bridge's ip address, orport, first seen timestamp,
 last seen timestamp, and distributor assignment in the database. Until now
 we've only needed this information, all other information is stored in-
 memory during runtime. With #13570 we need the bridge's PT information, as
 well.

 Unfortunately the current schema is not ideal for this, and it will very
 likely change with a migration to a different database backend. As such
 the easiest solution right now is to mirror the current class relation of
 PluggableTranport -> Bridge by creating a table with columns: addr, port,
 transport, fingerprint (?). #9652 would help simply this relationship, in
 the future.

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