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've basically locked the record. Hmm. I guess the problem is that the record would be locked for everybody, including the user that locked the record in the first place.
- [sqlite] using triggers to lock records Will Leshner
- [sqlite] Re: using triggers to lock records Will Leshner
- Re: [sqlite] Re: using triggers to lock records Kervin L. Pierre
- Re: [sqlite] Re: using triggers to lock reco... Will Leshner