Re: shared (database) file and multiple users
- Posted by ChrisB. Jul 03, 2008
- 729 views
Hi
Depends on the database you are using, but in most cases you have to lock and poll, especially over a windows or NFS LAN. Ie lock when writing (other users check for the locks, and can't edit until the lock is released), and poll, either on a regular basis, or when the user accesses the database to see if there are any updates.
You could write a little background deamon to constantly check for new data, but I would think that the best way to check would be for the users program to check whenever a significant action is performed.
I think that MySQL, Access, and postgress have some mechanisms to avoid concurrency (2 programs trying to write to the same database at the same time), but you have to be a little careful with sqlite, and I have no idea about eudatabase.
Chris