On Apr 7, 2005 7:44 AM, Kervin L. Pierre <[EMAIL PROTECTED]> wrote:
> I know your pain :) . Finer grain locking would be
> great.
Yes. We may simply be trying to use SQLite for something it just
wasn't designed for. On the other hand, if you are using SQLite as
your single-user database, it woul
Will Leshner wrote:
On Apr 6, 2005 10:43 AM, Will Leshner <[EMAIL PROTECTED]> wrote:
After thinking about this a bit more, I realized that writing a
trigger that didn't trigger for the locker is pretty simple. So I'm
thinking that triggers would work in this situation, but I'm wondering
if anybody
> After thinking about this a bit more, I realized that writing a
> trigger that didn't trigger for the locker is pretty simple. So I'm
> thinking that triggers would work in this situation, but I'm
> wondering if anybody has ever done anything like this before.
>
That really seems like a kludge
On Apr 6, 2005 10:43 AM, Will Leshner <[EMAIL PROTECTED]> wrote:
> How feasible would it be to use triggers as a way to implement record
> locking in SQLite? It seems like if you create a BEFORE trigger for a
> particular record id and have that trigger RAISE an error for updates
> and deletes, you
4 matches
Mail list logo
