When to Choose Optimistic vs. Pessimistic Locking in Ruby on Rails

Not every concurrent database update needs the same locking strategy. Imagine two users trying to book the last available seat on a flight. Both see that the seat is available and click “Book” almost