October 13th, 2004

pixelated

(no subject)

Bass Player (magazine): Is there any particular reason why you’ve never done bass solos onstage?

Steve Harris: Because they're bloody boring, that's why.
pixelated

(no subject)

What I'd like is a database operation to say "on commit add n to whatever the value in this field is at the time" without needing to lock the row for the duration of the transaction, or perhaps more generally "perform function f this field on commit".

The specific use I have in mind is something like keeping account records where you unconditionally insert detailed records into one table and update a balance for an account, you don't care about ordering however you want the inserted records and balance to be consistent and it's expensive to lock the account record for the duration.

Sigh - that all looks a bit OODBMS doesn't it? I'm being turned to the dark side.

...actually, thinking a little more, it's just syntactic sugar for a batch of UPDATEs to be performed immediately before the commit.