Re: [sqlite] Committing changes to the database without releasing a writer lock

2019-02-10 Thread Rowan Worth
On Fri, 8 Feb 2019 at 20:03, Theodore Dubois wrote: > I'd like to essentially commit changes to disk in the middle of the > transaction, resulting in a transaction that is atomic with respect to > other database connections but is two atomic transactions with respect to > the filesystem. >

Re: [sqlite] Committing changes to the database without releasing a writer lock

2019-02-08 Thread Simon Slavin
On 7 Feb 2019, at 9:53pm, Theodore Dubois wrote: > I'd like to essentially commit changes to disk in the middle of the > transaction, resulting in a transaction that is atomic with respect to other > database connections but is two atomic transactions with respect to the > filesystem. Would

[sqlite] Committing changes to the database without releasing a writer lock

2019-02-08 Thread Theodore Dubois
I'd like to essentially commit changes to disk in the middle of the transaction, resulting in a transaction that is atomic with respect to other database connections but is two atomic transactions with respect to the filesystem. When I first found the locking_mode pragma, my understanding was