[GNC] pros/cons of storage formats

Sébastien de Menten sdementen at gmail.com
Thu May 17 09:35:06 EDT 2018


Is the SQLite storage format immune to the issue regarding "very long time
to save the XML format" some users are experiencing?

On Thu, May 17, 2018, 10:46 David T. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> And, as I noted in January, the sql format does not get compressed, so the
> files are much larger.
>
>
>
>   On Thu, May 17, 2018 at 10:37, Adrien Monteleone<
> adrien.monteleone at lusfiber.net> wrote:   Keith,
>
> The SQL backends are having a few issues at the moment. It would be a good
> idea to search the list here and also to look over the bug reports on
> Bugzilla.
>
> I originally used MySQL when I was running an Ubuntu box as my daily
> machine, but changed to XML when I moved to MacOS, and then switched to
> sqlite3 about two years ago, but had to change back to XML since the 3.x
> series release due to several bugs related to the business features. (if
> you don’t use those, you might not have any problems)
>
> If all you want is the ability to run outside queries for custom reporting
> or data integration, then sqlite3 is probably your safest bet. MySQL and
> Postgres are much more involved to setup and maintain. Essentially, if
> you’re not a database admin, you probably don’t need those two or will not
> find any advantage to the maintenance learning curve and overhead, stick
> with sqlite3 or XML.
>
> As for searching the list archives, use the following syntax before your
> search query terms:
>
> site:lists.gnucash.org
>
> However, I see that DuckDuckGo does not return any results with this
> method.
>
> Google does, as well as StartPage. (the latter I find to be more privacy
> conscious than DDG and usually provides me more relevant results.) I
> haven’t tested any other search engines with that syntax.
>
> Regards,
> Adrien
>
>
> > On May 16, 2018, at 10:32 PM, Keith Keller <
> kkeller at wombat.san-francisco.ca.us> wrote:
> >
> > On Thu, May 17, 2018 at 03:21:13AM +0000, David T. wrote:
> >> I'm not sure how you looked,  but this topic had been discussed for
> many years on the list. A recent one was
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074315.html.
> Another was
> https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050410.html
> .
> >
> > Thanks David!  That January 2018 thread was helpful.  I'm not sure why
> > DDG didn't turn it up.  :(
> >
> > My impression is that the format really doesn't make an appreciable
> > difference to performance, and that a SQL format might be more flexible
> > for reporting but otherwise the formats are basically interchangeable.
> > Does that sound like a reasonable summary?
> >
> > I may simply stick with XML for now since it's easy and lazy.
> >
> > --keith
> >
> >
> > --
> > kkeller at wombat.san-francisco.ca.us
> >
> > _______________________________________________
> > 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
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> 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