Deepak Kaul said: > I was tasked to use sqlite on a NFS mount on MacOSX 10.4. I had > numerous problems with it because MacOSX does not implement locks > properly. It would run for about 15 minutes or so and then I would > start receiving Database Malformed errors. I had to come up with a > different solution. > > I came up with a scheme where only one process would handle updating the > database directly. All other processes locally or remotely would update > the database through a file hand shaking protocol.
This is pretty ingenious, but I really think that in a situation like this you'd be better off looking at something like PostgreSQL, that can handle multiple network clients. SQLite is a great tool, but it's not the only tool. Use the right tool for the job, and a file-based database is rarely the right tool when network access is needed. Clay Dowling -- Simple Content Management http://www.ceamus.com
