If you want to do something like this, the only thing necessary is to synchronize access to your data layer. In other words, only one thread of execution should be able to access your Sqlite db at one time. To accomplish this, here is a simple solution. If you have not already put all data access routines in a single class in a single library (dll assembly), you will need to do this to do easy thread synchronization. Once you have all of these routines in a single class, simply use a monitor (.NET thread sync object) to obtain a lock at the beginning of every call in the class, and release the lock at the end. This will ensure that you can your Sqlite db works properly.
| = thread synchronized data access object Web Application -> | Data Layer -> (data adapter) Sqlite DB This is the only for sure way I know of to guarantee data integrity and make sure you always get a data return, insert, or update when something occurs on a web page (assuming you wrote your code properly!). If you don't do this Sqlite appears to throw out an error saying the database is locked (and your transaction does not go through). If this occurs, your website might not have worked properly in view of the user. Thanks, Allan -----Original Message----- From: Greg Obleshchuk [mailto:[EMAIL PROTECTED] Sent: Sunday, October 26, 2003 11:21 PM To: [EMAIL PROTECTED] Subject: [sqlite] SQLite in Web application Hi Everyone , I would like some opinions from anyone with experience in this area. I am thinking of replacing the MS SQL Server backend to my web site with a few SQLite databases. I use the database backend to record purchases and store client information. I also record things like software paths and download times. What my concerns are is SQLite ability to handle web type traffic. If two or more people are using the download form, this form opens a SQLite DB and tries to insert information into the table will all the inserts work? I am planning to use it via ASP.NET and IIS 6.0 So if anyone is using SQLite in a web application that is used by lots of people I would love to here about any problems or just of your success. Kind regards Greg O --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
