SQLite is a desktop application, not a network aware application. The file locking mechanisms lie to SQLite which makes it an EXTREMELY HIGH CHANCE that connectivity and any WRITE statements WILL cause data corruption.
This isn't the fault of SQLite but the network file system locking. AFAIK, there is no network file sharing utility that works 100%. Windows and Linux based systems are affected. The problem is that the 'server' doesn't handle multiple file locks properly because it is treating the file as a 'file' not as a data source. Multiple copies of your application consider the data to be theirs, so, if data is being written to the WAL file, or directly to the database, the server is going to treat both with the same regard and potentially write the data out of order. Their preference probably will cause data loss. http://www.sqlite.org/whentouse.html Under the "Situations Where Another RDBMS May Work Better" section, the first paragraph illustrates what I mentioned above. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
