[GNC] Post crash recovery log file suggestion

[David G. Pickett]

John,

So, less code.  It seems odd that they wrote the code for the replay but do not automatically do it, making it a hidden feature.  Hopefully it is truncated or a new log started with every save, so duplicates are not a problem.

My saves are not slow, but the huge number of huge files slows my backup to my cloud.  GNUCash files are probably the second largest part of my storage after pictures!  We discussed since-save and incremental-save previously.

I think my original GNUCash used an RDBMS, and that was fine.  I am not sure how to turn that on, or what additional files I would need to back up!  Currently, I can open my backup GNUCash files on my second PC, but I am not sure with RDBMS that I could still do that.
Best,
David


-----Original Message-----
From: john <jralls at ceridwen.us>
To: David G. Pickett <dgpickett at aol.com>
Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Sent: Sat, Jan 15, 2022 5:21 pm
Subject: Re: [GNC] Post crash recovery log file suggestion


> On Jan 15, 2022, at 11:10 AM, David G. Pickett via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> As 4.9 does abort ungracefully from time to time, I grow weary of reentering my unsaved transactions.  I suggest that you post them to a new sort of log file as I go, so I do not have to save megabytes of almost duplicate files so often to avoid this.  Of course, if I leave the cursor on a modified line, I still might lose that line, unless you can log that along with its state when I change tabs.  (Maybe I should be warned when I change tabs that I left an uncommitted transaction, not later when I save?)  When the app starts, it can check the file and replay.  When there is a save and the normal files are closed or flushed to disk, the new log file can be truncated.  It'd be very much like an RDBMS log.  And perhaps a way to allow us to save less often?

We do, that's what the *.log files in the same directory as your data file are. Note, though, that they log only transactions and their splits. Nothing else, especially not the business stuff, is logged.


To re-enter them use File>Import>Replay GnuCash Log File.

You could enable auto-save in preferences, but when that runs it blocks the UI so it can be a bit tedious if you have a large file. You might also consider the SQLite3 backend that writes the database immediately when you complete a transaction, at the expense of not making a backup file and not being able to quit without saving if you decide you've made a mess of a session.

Regards,
John Ralls