Hello!

I have never been working with databases before and I got a question
I wonder, I use a database where I stor 90 persons and their personalinformation an their tennisscores.
Is it possible for two or more people to read/write from/to the same database as long they are not working with the same post?
There is no heavy traffic so the probability that this occur is not big...but anyway.

If not, is there a way to handle this?

Thanks / Digital_storm

90 persons? I don't think that would be a problem at all for a database system like MySQL. I've used flat files to store about 2000-3000 lines of entries for a small web application and I don't remember encountering any major problems.

But it's good to start with a proper database system, however small the database might be.

You don't want to assume that there will not be any edits to the same record at the same time. You need to take a look at how MySQL protects database integrity. For the MySQL way of doing things, check out http://www.mysql.com/doc/en/LOCK_TABLES.html and for the transactional way of doing things check out http://www.mysql.com/doc/en/COMMIT.html. It is better to take a few simple steps to protect the database integrity than to take the chance that you won't have to worry about database integrity.

Hello!

Thank you!

Regards // Digital_storm