http://www.perlmonks.org?node_id=518467


in reply to Locking a table row while web form is open

Why are you looking at these complex solutions? Is there a problem with a simple pessimistic locking approach, like creating a lock file when someone goes to the edit page and removing it when they save or adding a "signed_out_by" column in the database table? There are issues with people leaving that screen open and walking away, but you can use javascript and timeouts to help with that.