Re: [SQLObject] Woven+Twisted

[Brad B. <br...@bb...>]

On Tue, Aug 26, 2003 at 07:26:19PM +0100, Oisin Mulvihill wrote:
[snip Ian's comments]
> Hi,
> 
> I said this already but I've used twisted and sqlobject successfully. I use

Eh, it may *look* like you have. :) SQLObject is synchronous, Twisted
is asynchronous, there's no compatibility here.

e.g.

Person.select("hair_colour = 'blonde'")

In Twisted, every method call must return as fast as possible
(basically, instantly). In the above .select() is at the mercy of how
many blondes you have in your system. By extension, so is the rest of
your code; nothing else will get executed until that .select() comes
back.

A deferred (in Twisted) doesn't solve this, because .select() doesn't
know how to be asynchronous anyway so the code will block no matter
what you try to do.

> twisted and sqlobject together in a call card top up system running on
> a linux server, which has been running without problems for the past few
> months.

Interesting, but dangerous. Rest assurred if your system encounters
non-trivial load you'll need to rewrite it (by replacing SQLObject
with adbapi in Twisted.)

--
Brad Bollenbach
BBnet.ca