Database Transactions: The Isolation Level You're Probably Not Setting
Your database has four isolation levels, each with different guarantees about what concurrent transactions can see. Most developers never change the default -- and that default might not be what you think.