I am redesigning a large enterprise web system and a major concern has come across the table. The system allows for many users to Create, Read, Update, and Delete items in the system. This is problem if two or more users are editing the same file or item.
What is a good technology or approach to integrate on this? Several things must be considered, for example:
- User may not delete an item if another user is updating it
- An item in editing, should be eventually released so that the user is not holding on to it forever and prevent someone else from editing it
- Make new items/new changes available even while on editing mode (for example, in Stack Exchange, if someone posts an answer to this question while I am writing my own, a dialog appears that says an answer has been posted to this question. I am not able to see it, but as soon as I finish my edit, I can see the answer without refreshing the screen)
If your suggestion comes with more features out of the box or you have any added suggestions or caveats, I am open to them.