great weekend read: excellent, simple, practical examples of what *isolation* means in a database. showing how MySQL and PostgreSQL actually give you different results when you run the same queries in the same order! even in the same isolation level!!! postgresql.verite.pro/blog/2020/02/1
Conversation
That's a great question; in my years working with both Oracle and PostgreSQL, so far I don't think I've touched an application that explicitly used Repeatable Read. Can the interwebs find someone who uses RR on purpose? I suspect most people code around their DB default.
1
1
Presumably it was much more common back when the set of behaviors we now call "repeatable read" were called "serializable" (which was rather inaccurate). I believe that Oracle's serializable is just RR to this day.