Sometimes, race conditions cause your data to get overwritten.  I find it useful to add a

lock_version:integer

 field to my tables to help prevent this.

Absolutely. For a more detailed look into optimistic locking, there is a recent episode on the topic. https://www.driftingruby.com/episodes/optimistic-locking