[Buildbot-devel] New, more efficient web stuff

[Jean-Paul Calderone]

On Fri, 4 Jan 2008 11:43:16 -0500, "Dustin J. Mitchell" <dustin at zmanda.com> wrote:
>On Jan 4, 2008 11:29 AM, Jean-Paul Calderone <exarkun at divmod.com> wrote:
>> I suggest taking a look at http://divmod.org/trac/wiki/DivmodAxiom for
>> storage.
>>
>> Even if you decide against that, I suggest not basing anything on Twisted
>> Enterprise.
>
>Any particular reason?

I didn't really address this in my previous message.

I recommend against twisted.enterprise for a few reasons.  In no particular
order:

  * it has poor test coverage, it was written at a time when standards were
    much lower than they are now, it has received little maintenance over the
    years (granted, this is because it does what people expect of it), and it
    involves threads which is an annoyance for testing code that uses it.

  * it deals with disconnection by exposing it to the application.  This isn't
    necessarily bad, but disconnection is a fairly low level detail, so it's
    inconvenient to have to deal with, and people often forget to or don't for
    some other reason.

  * likewise, the interface it offers for interacting with and manipulating
    data is very low level.  You give it some SQL, and it executes it, and
    then you get results out.  It's basically tuple-oriented programming,
    which is annoying.  Plus, you get all the annoying features of DB-API 2,
    like having a variable interpolation syntax.  Do you write SQL statements
    with ? or %s or \1 or \name or what?  You have to dynamically generate
    the statements at runtime based on the DB-API 2 module being used.

  * You have to write SQL.  Maybe this doesn't bother you as much as it
    bothers me, though. ;)

Jean-Paul