Understanding Consistency in Databases: Beyond the basics
What to do when dealing with N multiple transactions at the same time?Most of the time we perform CRUD operations under the pragmatic standard transactional scope, thinking it will suffice under all circunstances. After all, what could go wrong when we always apply a standard ACID tool provided by our frameworks, right? But it feels “good enough” only until we face corner cases of the real world production traffic: missing rows after pagination, duplicated updates, or metrics that refuse to add ...
Read more at medium.com