Re: [sqlite] Need SQLite datafiles to be locked on OS level (Windows)

Thanks for your responses. Actually we have two problems: a) "database is locked" which in majority comes from sqlite3_step doing BEGIN IMMEDIATE which indeed is obtaining a write lock Basically we have just one connection per one datafile except one case when we have two connections for one da

[sqlite] Need SQLite datafiles to be locked on OS level (Windows)

We need to lock our SQLite datafiles at the filesystem level, because our application frequently crashes with "database is locked" error, which is probably due to other processes opening our files. At least we identified Windows Search indexing service and McAffee antivirus. I have tried exclu