Backend & systems·Transactions and isolation
you only see other transactions' work once they commit, but two reads inside your own transaction can still disagree.
Read committed
The common default isolation level: each statement sees a snapshot as of when that statement started. It rules out dirty reads and nothing else. Any logic that reads a value, decides something, and writes based on it is unsafe here without explicit locking.