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

by Martin Kleppmann

This is why transactions exist: they are a way for a database to provide stronger guarantees so that the application can be simpler.