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

[Darren Duncan]

-------- 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:
[snip]
> 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.