Sam Gendler wrote:
Does zope have some kind of locking around the ZSQLMethods, or is there a chance that another query could slip in between the first and the second query. If there is a guarantee in zope that a single ZSQLMethod will execute in a threadsafe manner, I am comfortable with it. I can make sure that there is no insert access from outside of zope. Of course, this becomes a problem againa as soon as you use Zeo for anything (something I was planning to do), since there will presumably be a different database connection from each zope instance, so no way to do this without locking of some sort. I can feel a switch to postgresql or oracle coming on... (Ugh!)
--sam
<CUT> It sounds a bit like you fear PostgreSQL (I don't know Oracle)...?! You have nothing to fear, I say. PostgreSQL is really nice to work with and lots of features that MySQL and others... ehh... has not. I dig PostgreSQL! -- Best regards / Mvh., Steen Suder sysadm kollegie6400.dk OpenSource --- Sign of the time