FWIW, I'm not convinced Samba has locking working correctly. Using a very recent Samba version, I managed to corrupt a SQLite database last fall by (I think) doing simultaneous writes from the Linux host box, and my WinXP client box (via a SMB drive map). I'm guessing the XP writes started first. It seems unlikely it would have happened had the Linux host started first.
Maybe it was something else, but given the explanations I've seen of what's known to corrupt a SQLite DB, it seems pretty likely it was a locking issue with a network file system. Fortunately, it was early in the dev process on that project, and there wasn't much data in the DB, and I was able to recover it with a text editor. That I didn't have a copy of the data outside the DB points to a weakness in my development habits. Gotta work on that. -Clark ----- Original Message ---- From: Dennis Cote <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, February 2, 2007 7:49:55 AM Subject: Re: [sqlite] Appropriate uses for SQLite [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. Hi All, If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue on older implementations of NFS where the file locking does not work correctly. I believe that SMB (windows shares and Samba) do work correctly. I also seem to remember someone saying that current versions of NFS work correctly. It seems like overkill to say SQLite won't work an all network file systems, when in fact it will work on some, perhaps even most. I appreciate that there are still network latency issues that will impact performance, but that is a separate issue. Many users could accept the lower performance as long as they don't have to worry about corruption. I'm sure someone knows which versions of NFS have working file locking, at least under Linux. Perhaps we can collect this information about network file systems that are known to work and those that are known to have problems and post them on the wiki. Right now this issue seems to be handled more as folklore than science. So, what works and what doesn't? Let me know. Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
