[tor-bugs] #12031 [BridgeDB]: Create a Key-Value RDBMS system for simple/flat datatypes in BridgeDB

[Tor Bug Tracker & Wiki]

#12031: Create a Key-Value RDBMS system for simple/flat datatypes in BridgeDB
-------------------------+-------------------------------------------------
     Reporter:  isis     |      Owner:  isis
         Type:           |     Status:  needs_revision
  enhancement            |  Milestone:
     Priority:  major    |    Version:
    Component:           |   Keywords:  bridgedb-1.0.x, bridgedb-db,
  BridgeDB               |  proposal-226
   Resolution:           |  Parent ID:
Actual Points:           |
       Points:           |
-------------------------+-------------------------------------------------
Changes (by isis):

 * status:  new => needs_revision


Comment:

 Replying to [comment:1 wfn]:
 > fwiw, I can vouch for Redis being an excellent product.
 >
 > Set intersections are crazy fast. Main datatypes (if you could call them
 that) (sets, hashtables) work very well indeed.
 >
 > Very minor nitpick: a key-value store is not an
 [https://en.wikipedia.org/wiki/Relational_database_management_system
 RDBMS]. :) this probably doesn't matter, but it could confuse some
 onlookers / people trying to help (or maybe not.)

 Derp. I meant "an RDBMS for interacting with key-value stores in Redis".

 I intended there to be a database management system, which one one side
 would have an API for taking/answering queries from bridge distributors,
 and on the other side, would handle talking to whatever the databases on
 the backend are.

 I decided to go with using [https://pypi.python.org/pypi/txredis
 `txredis`], even though it has some problems. Work so far on this is in my
 `fix/12031-redis`
 [https://gitweb.torproject.org/user/isis/bridgedb.git/shortlog/refs/heads/fix/12031-redis
 branch]. Tests are totally '''[https://travis-
 ci.org/isislovecruft/bridgedb/builds/28244260 not] passing''' yet. See the
 commit messages in that branch for design a couple major design choices
 and some problems encountered so far.

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