Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    28

    Unanswered: A newbie question regarding acces to a database

    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

  2. #2
    Join Date
    Nov 2003
    Location
    Sinapore
    Posts
    187
    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.

  3. #3
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137
    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.

  4. #4
    Join Date
    Dec 2003
    Posts
    28
    Hello!

    Thank you!

    Regards // Digital_storm

    Originally posted by aus
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •