[Buildbot-commits] [Buildbot] #1770: rewrite database support using SQLAlchmey

[Buildbot]

#1770: rewrite database support using SQLAlchmey
------------------------+----------------------
Reporter:  dustin       |      Owner:  dustin
    Type:  enhancement  |     Status:  new
Priority:  major        |  Milestone:  0.8.4
 Version:  master       |   Keywords:  database
------------------------+----------------------
 The current database support is hand-rolled and a bit buggy.  It runs
 user-specified code in threads, which can lead to bugs, and also runs a
 lot of database transactions in the main thread, which is slow and makes
 Twisted sad.  It's also fairly specific to MySQL and SQLite.

 We should use SQLAlchemy to generate queries, and be careful to always run
 them in a thread and make them return a deferred.  This should be done
 using a clean database API split into multiple modules, and all of it
 tested thoroughly.

 Also, one palomino pony please.

 This is currently in development at
 http://github.com/djmitche/buildbot/commit/sqlalchemy, and parts are
 committed to master already.

-- 
Ticket URL: <http://trac.buildbot.net/ticket/1770>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation