[GNC] XML or database?

John Layman john.layman at laymanandlayman.com
Mon Oct 31 12:16:16 EDT 2022


I initially configured GnuCash for periodic backups, but found the
disruption annoying.  You are free to save the file at will, and, yes, if
the file is "dirty" you'll get a reminder when you exit the program.

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+john.layman=ieee.org at gnucash.org>
On Behalf Of R Losey
Sent: Monday, October 31, 2022 11:15 AM
To: Derek Atkins <derek at ihtfp.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] XML or database?

That helps - thanks!

I assume that if I attempt to quit GnuCash with unsaved data, it will remind
me to save... but the current indications of unsaved data files have been
sufficient to remind me to save the data.

If you have data going back 15 years, I'm just getting started with 6 years
(heh).



On Mon, Oct 31, 2022 at 8:31 AM Derek Atkins <derek at ihtfp.com> wrote:

> Hi,
>
> On Mon, October 31, 2022 9:14 am, R Losey wrote:
> > This question may have been asked before, but I'm relatively new to 
> > this mailing list.
> >
> > Is there any advantage to switching to the database format? Would it 
> > use less space? My ".gnucash" file is about 1.5M currently, and 
> > opening it takes mere seconds.
>
> The main advantage of using the SQL backend is that all changes are 
> "saved" immediately, so you wont lose data because you "forgot to save"
>
> But no, the DB is most definitely NOT smaller; the XML file is 
> compressed on save, so that 1.5MB would probably be more like 10-20MB of
DB.
>
> > Long ago in my Quicken days, I would generally keep about 3 years of
> data
> > and then "archive" transactions older than that... I don't know if
> GnuCash
> > has (or needs) any similar feature.
>
> For what it's worth, I have data going back to like 2007 in my file.
> GnuCash does not really have an "archive" function (although there 
> have been 3rd party tools that do that.
>
> Hope that helps!
>
>  _________________________________
> > Richard Losey
> > rlosey at gmail.com
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins                 617-623-3745
>        derek at ihtfp.com             www.ihtfp.com
>        Computer and Internet Security Consultant
>
>

--
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list