Views Counter raise condition

[MikeAlhayek]

@hishamco I came across this on LinkedIn and took a look at the code out of curiosity. One thing to be aware of is that this approach can fail when more than one user is viewing the same article at the same time. There’s a race condition between updates.

This becomes an even bigger issue when you have many concurrent readers and someone editing the article at the same time—an editor could potentially lose their changes while others are viewing the content due to the same race condition.

In my own implementation, I also track views, but I handle it differently by using a ShapeTableProvider and executing a raw SQL update to increment the counter atomically, which avoids these concurrency issues.

Just wanted to share this in case it’s helpful.

[hishamco]

Thanks for your feedback @MikeAlhayek I might prefer to go without ShapeTableProvider. I will try to create a unit test to simulate the case, if it's possible, then I will do a fix