Multiple user sessions at the same time in a backoffice
I am currently working on a project for a veterinary practice and one of its components is a web-based backoffice for general management. The practice already has a backoffice-style software, but it's lacking in some features and it's only required for legal reasons. I was thinking about the authentication process the other day and I came up with the following questions/scenarios:
What will happen if I have two or more instances (tabs) of the backoffice opened in the same browser, on the same machine, with different user sessions? Will the session data for each user get corrupted? The reason for this is that there's only one computer in the practice for multiple workers.
What if there are house calls and one vet has to stay behind in the practice, while the other goes away? Seeing that I'll be making the backoffice responsive, the vet that answers the house call could open an instance of it on a tablet and register the information on-site. But, at the same time, the other vet is, perhaps, also accessing the backoffice.
I don't know if I made myself clear, but I'm seeing a problem with session concurrency.
I'll be using MySQL as the database, I think it supports concurrent access to the tables.
Any ideas?
