What i normally do in this scenario is just a simple httpd service restart.
That normally does the trick because i am building an application also with PHP/Sqlite. On Mon, 2006-03-20 at 06:47 -0500, [EMAIL PROTECTED] wrote: > Mark Robson <[EMAIL PROTECTED]> wrote: > > > > If the answer is "nothing", I'm going straight over to MySQL :) > > > > The advantages of SQLite are that there are no administrative > hassles - there is nothing to set up or configure and the > database is contained in a single disk file that you can copy > to a flash drive or something. Client/server database engines > like MySQL normally default to READ COMMITTED isolation, which > means you never have database locking problems, but at the expense > of considerable setup and configuration complexity. > > It sounds to me like you are more interested in READ COMMITTED > isolation and do not mind the added complexity, in which case > you should be using a client/server database, such as MySQL. > > BTW: Lots of people have multiple processes writing to the same > SQLite database without problems - the SQLite website is a good > example. I do not know what you are doing wrong to get the > locking problems you are experiencing. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> >