[DBD-SQLite] [Fwd: Re: [sqlite] SQLite version 3.7.0]

Darren Duncan darren at darrenduncan.net
Thu Jul 22 18:31:55 GMT 2010

-------- Original Message --------
Subject: Re: [sqlite] SQLite version 3.7.0
Date: Thu, 22 Jul 2010 14:27:01 +0200
From: Filip Navara <filip.navara at gmail.com>
To: General Discussion of SQLite Database <sqlite-users at sqlite.org>

On Thu, Jul 22, 2010 at 1:31 PM, Dan Kennedy <danielk1977 at gmail.com> wrote:
> You cannot delete a file while it is open on windows, so
> this doesn't come up on win32.

Sure you can, except:
- The correct sharing rights have to be specified for this to be
allowed (FILE_SHARE_DELETE). As far as I know SQLite opens the files
without this sharing right.
- The file is deleted after the last handle to it is closed. This
means that the same filename couldn't be reused until all the handles
are closed.

More information about the DBD-SQLite mailing list