If anyone would like to learn more about this topic, Jepsen has some great articles on isolation levels and consistency models.

https://jepsen.io/consistency