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

Reply via email to