On 7 Feb 2019, at 9:53pm, Theodore Dubois <[email protected]> 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 SAVEPOINT work for you ? <https://sqlite.org/lang_savepoint.html> The thing you're actually asking for doesn't happen in SQL. The state of the database on the disk (including the journal file as well as the database file) is meant to reflect what other connections are seeing. I don't think we can do exactly what you asked for. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
