On 7 Oct 2019, at 10:34am, Fredrik Larsen <frel...@gmail.com> wrote: > In my head, checkpointing implies copying back all dirty-pages from the > WAL/COW-log to the main db-file. If we never checkpoint, the writes are still > completed, but lives in the WAL-file. We will offcourse merge back pages to > the main db-file, but this would be an offline process we start when we want > to create a new "base-image" of the db. For this to work, it is very > important that the main db-file is untouched until we actively want to update > this file.
Your use of SQLite depends on several obscure facts about how SQLite works. If you ever want to change implementation details you're going to need someone who understands SQLite very thoroughly. Had you considered just making a text file of all the SQL commands executed, and running that against your main database file ? It would take less CPU time, less filespace, be easier to debug, and be simpler for another programmer to understand. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users