[sqlite] using triggers to lock records

[Will Leshner]

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.