I suspect David was thinking of CuteCash, Christian Stimming’s experimental Qt GUI.
Regards, John Ralls > On Jan 27, 2018, at 10:44 AM, Sébastien de Menten <sdemen...@gmail.com> wrote: > > Hello David, > > I saw you were mentioning piecash in your message. If you talk about > http://piecash.readthedocs.io/en/latest/, it is not a proof of concept for > a frontend but an alternative to the gnucash python bindings to work with > gnucash books stored in any of the 3 SQL backends (SQLite, postgres and > MySQL) and is alive and maintained (last release on the 20th December 2017). > > The following article https://arachnoid.com/gnucash_utilities/ shows some > interesting use cases for it. > > With gnucash 3.0, piecash will also allow you to write your own reports > using si python and jinja2 (work in progress). > > For people interested to contribute, https://github.com/sdementen/piecash. > > > On Jan 27, 2018 18:27, "D via gnucash-user" <gnucash-user@gnucash.org> > wrote: > > Mike, > > There is nothing new as far as I know about the file formats. You are right > that the primary benefit to using sql is being able to generate data sets > from sql that can used in reports. Processing a data file is no quicker in > sql, since it all gets loaded in at start up. Sql, moreover, adds a > database manager role to the mix; many users are not prepared to learn how > to manage a database platform to manage their financial accounts. > > I stick with the XML because it also can store the data compressed; when > dealing with the main data file and all its copies, the difference between > 3mb and 13mb adds up quickly. > > Piecash, as I understand it, was a proof-of-concept experiment to see > whether a python front end could be designed. It has not been maintained > for some years now, and I recall recent discussion about changing its > status with the project. > > As far as I know, there has been no change in recommendation to stay with > xml. > > David > > On January 27, 2018, at 12:13 PM, Adrien Monteleone < > adrien.montele...@gmail.com> wrote: > > I switched from XML to SQLite about a year ago. I perceive a performance > improvement on loading, but that’s about it. (and I generally never shut > the app down anyway) > > I haven’t attempted any custom reporting yet, but I plan to. > > I could be mistaken, but I think PyCash is designed to parse the XML file > so you can still get the reporting you want. > > Regards, > Adrien > >> On Jan 27, 2018, at 12:55 AM, Mike Stillingfleet < > mikestillingfl...@fastmail.co.uk> wrote: >> >> Dear All, >> >> XML is the default when creating a new file. >> >> I have seen various quite dated questions about the decision process of > selecting which db to use. >> >> I think that the main advantage of using MySQL would be the ability to > generate custom reports. >> >> Are there any other advantages and are there any differences in the > interface between the various db's. Does the forum still recommend XML. >> >> Regards >> >> -- >> Mike Stillingfleet >> mikestillingfl...@fastmail.co.uk >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> 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. > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org 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.