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@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.montele...@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 < > kkel...@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 > > > > > > -- > > kkel...@wombat.san-francisco.ca.us > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@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@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@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@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.