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 <[email protected]> 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 > <[email protected]> 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 > [email protected] > _______________________________________________ > gnucash-user mailing list > [email protected] > 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 [email protected] 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 [email protected] 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.
