Mikey C uttered:
Hi,
Maybe I didn't make the question clear. I'm not talking about locking and
multiple writers. I'm talking about optimistic concurrency control in a
disconnected environment.
Two processes (say a webserver). One reads some data and presents it to a
user (open - read - close). The other reads the same same data and presents
it to another user (open - read - close). The first user updates the data
(open - write - close). Several seconds/minutes later the second user
updates the same data (open - read - close). Result is the first users
changes are lost.
Aha. OK, I see where you're coming from.
ALL I am asking is could SQLite give each table a special column that
increases it's value for each row whenever data changes?
I could implement is with a trigger on each table BUT it would be nice if
SQLite supported this natively.
Anyhow, I get from the tone of the answers that this is not likely to
happen, so I'll code it up myself.
Sorry if I sounded arsy. I wasn't trying to, I was just trying to be
succinct.
Cheers,
Mike
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
