Re: [sqlite] Manual flush before commit

2010-02-13 Thread Simon Slavin
On 14 Feb 2010, at 6:49am, Michael Tharp wrote: > On 02/14/2010 01:09 AM, Simon Slavin wrote: >> read the distinctions between the different types of 'BEGIN'. > > I don't see any mention of flushing behaviour, just earlier locks. I > guess what I'm asking for is a lightweight two-phase commit,

Re: [sqlite] Manual flush before commit

2010-02-13 Thread Michael Tharp
On 02/14/2010 01:09 AM, Simon Slavin wrote: > read the distinctions between the different types of 'BEGIN'. I don't see any mention of flushing behaviour, just earlier locks. I guess what I'm asking for is a lightweight two-phase commit, which seems easy enough to do given the current

Re: [sqlite] Manual flush before commit

2010-02-13 Thread Simon Slavin
On 14 Feb 2010, at 5:32am, Michael Tharp wrote: > I see that a sqlite commit is split into two distinct phases, the first > being acquiring an exclusive lock and flushing dirty pages and the > second being the unlinking of the journal which constitutes the actual > commit. I would like to

[sqlite] Manual flush before commit

2010-02-13 Thread Michael Tharp
Hullo, I have a package manager that consists of a sqlite database combined with a filesystem journal that is created during system updates. The journal contains enough information to clean up the filesystem if an update is interrupted by e.g. a power failure. Naturally, these two journals