Çağlar Orhan wrote:
While i was reading "*Using SQLite*" from *Jay A. Kreibich*, i saw that sqlite doesn't designd for over network multiple client connections. I have a project that built on Microsoft .hta and vbscript. And I am using sqlite on the IIS for local storage but, 5 to 10 client applications connecting as a network database to that sqlite. SQLite file is in a shared folder. I made some test that 2 or few more clients inserting, updating and query same tables. I couldn't catch any inconsistency about table integrity. But on the book, because of there is no native support for providing access to multiple computers over a network, cause problems. Like database file corrupt etc. Is there a solution for network shared sqlite problematic?
If your SQLite DB is being accessed locally by the webserver, then there is no reason to worry about consistency issues due to the webserver's network activity, provided that your application can handle the access delay issues that arise when multiple threads may attempt overlapping DB operations. If you are happy with the performance and the number of clients is not likely to grow much, SQLite could be a good solution.
What Jay and others warn about is that SQLite is not designed for concurrent DB operations. Also, have its file store be accessed over a network from SQLite code running remotely is a formula for database corruption. But it looks like you are not doing that.
Thank you
You're welcome. -- Larry Brasfield _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
