REPEATABLE READ is an intermediate level of isolation that inherits a few of the drawbacks of both its weaker and stronger neighbors. It’s an excellent balance between consistency and concurrency in conditions where it’s necessary to see only committed knowledge (so, no soiled reads) but minor inconsistencies between reads (like non-repeatable reads) are acceptable. In… Continue reading No Soiled Reads: Every Little Thing You Always Needed To Find Out About SQL Isolation Levels But Have Been Too Afraid To Ask