On 5/16/06, Chaz. <[EMAIL PROTECTED]> wrote:
Has anyone used SQLObject with sqlite on the Twisted framework?  I would
like to know if there are any "gotchas" that I should watch out for
before beginning.

It depends on your exact usage. Generally speaking, they are
incompatible. SQLObject database access is potentially a blocking
operation, so you don't want that to happen inside your main Twisted
event loop.

If your database access is fast enough (and it *can* be with sqlite),
you can just fudge it and use SQLObject. But, if any database access
takes time to run, it will hold up your whole application.

Another alternative is to put all of your database access on a thread
or threads (deferToThread).

Kevin


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to