Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

the second-best option in this case is probably to explicitly lock the rows that the transaction depends on.