This is interesting. I think developers should be more aware of how the DBMS works under the hood. Edit: In my case, I still use row-level lock when implement

This is interesting. I think developers should be more aware of how the DBMS works under the hood. Edit: In my case, I still use row-level lock when implementing the state machine pattern on a model. It enforces the application-level-consistency of the model state, preventing double updates in case of high concurrency, in which the second (concurrent) update would break the application logic.