[GNC] XML or database?

[David H]

An advantage of using the xml backend and leaving autosave turned off is
that you can just quit out of Gnucash if you inadvertently screw something
up as it's not saved after each txn as per sql :-)

Cheers David H.


On Tue, 1 Nov 2022 at 01:15, R Losey <rlosey at gmail.com> wrote:

> 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.
>