acid

A comprehensive guide to core system design building blocks, including client-server architecture, scaling, and databases, to help with system design problems and interview preparation.

This article argues that using weaker database isolation levels as default is a form of premature optimization, and recommends serializable isolation level unless the DBMS already defaults to it. It cites real examples of concurrency bugs leading to financial losses.