[tor-bugs] #2392 [Torflow]: Support PostGre/mysql backend

[Tor Bug Tracker & Wiki]

#2392: Support PostGre/mysql backend
-------------------------+--------------------------------------------------
 Reporter:  mikeperry    |          Owner:  mikeperry
     Type:  enhancement  |         Status:  new      
 Priority:  normal       |      Milestone:           
Component:  Torflow      |        Version:           
 Keywords:               |         Parent:           
   Points:               |   Actualpoints:           
-------------------------+--------------------------------------------------

Comment(by aagbsn):

 This fix lived here https://github.com/aagbsn/torflow/tree/ticket2392. It
 has since been merged into master.
 The changes consist of:

 1. rewriting queries so that UPDATE target and source tables are not the
 same
    (this is achieved by using nested SELECT which cause MySQL to generate
 temporary tables)
 2. rewriting queries to avoid divide-by-zeros.

 3. adding a new configuration parameter, db_url, to bwauthority.cfg which
 specifies the database type:

 # if db_url is unset bwauthority will default to sqlite
 #db_url =
 #db_url = mysql+mysqldb://bwscanner:password@127.0.0.1/BwScan1
 db_url = postgresql://bwscanner:password@127.0.0.1/BwScan1

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