IME in this model, the middleware-DB transaction were set to be serializable, but the web-user-edits were done under an optimistic concurrency model, using versions or timestamps. You’d run into edit conflicts, which for many applications is a reasonable compromise.
The DB transactions would need to be kept open for user edits only if one were using a pessimistic model.
Am I thinking about this correctly?