On Wed, Mar 01, 2006 at 12:44:47PM -0600, Jim C. Nasby wrote:
[...]
> Depending on your needs, you might be able to just lock a row for
> updates and hold that lock. IE, open a seperate connection to the
> database and do:
>
> BEGIN;
> UPDATE process SET start_time = now() WHERE process_id = ?;
>
> And then 'sit' on that connection until you're done. When you're
> finished, just issue a COMMIT. Note that some databases won't like you
> leaving that transaction open a real long time, so it depends on what
> you're doing if this will work. I also don't know if SQLite cares about
> such things.
[...]
sqlite mostly cares about such things, but it goes the
"lock the whole db" way.
I'd love row level locks, right!
I already considered adding some "this_row_locked" column
to a table, just to emulate row level locking.
Elrond
