Can someone please explain how concurrency affects a web application?
Anything helps! Thanks.
This is a super broad question but the common sources of concurrency errors from base of app up are:
I can't recommend Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems highly enough which provides a foundation into all the important concepts your concerned about!
A concrete example using CQRS:
A transaction makes a request to persist information to the writer and then immediately reads back from that reader. Depending on your CQRS implementation it's possible there are only eventual consistent guarantees between writes and reads, meaning the read may not see the just written data! Of course this may ore may not be an issue depending on your client.