A Comparison of Scalable Database Isolation Levels

The pretense of low maximum isolation levels, eventual consistency, or CRDTs is that application developers are ready and willing to work through every failure and recovery condition of their distributed dataflow. In my experience, the implications of different isolation levels in practice are very subtle, and pushing the burden to the application developers—especially when there are a lot of distinct applications, like in a microservices architecture—is tremendously detrimental to productivity. At Fauna, we encourage you to think critically about whether your current databases really guarantee the level of transactional isolation you need.

Source: fauna.com