Trying ZODB, background in Relational: mimic auto_increment?

[Christian Heimes]

Diez B. Roggisch wrote:
> But that's a great deal more complicated! It requires merging, and while 
> this of course is possible, you should have mentioned it because 
> otherwise the OP might run into problems.

A lock doesn't do the job at all. ZODB supports clustering through ZEO. 
Multiple ZEO clients can be attached to a single or more ZODB servers. 
Any kind of thread based locking is local to each ZEO client.

You have to sync a sequence generator across multiple ZEO clients, hook 
into the two phase commit protocol or use the conflict resolution hooks. 
The problem is more complex than you think.

Christian