[GNC] Using a mysql database?

John Ralls jralls at ceridwen.us
Tue Mar 12 19:33:47 EDT 2019



> On Mar 12, 2019, at 3:39 PM, Jacob Larsen <jacob at larsen.net> wrote:
> 
> Hi
> 
> How reliable is my data if I move from an XML file to a mysql database? I just tried saving my books in a mysql (MariaDB) database, reload from the database, and then saving back to an XML file. The files are of the same size, and they have a large chunk that is identical on both sides in my difftool. But there is also a large chunk that differs, so most likely the order is shuffled. I started xmldiff on it just to see what it finds, but that tool has not yet returned.
> 
> Does anyone here know if there are any issues with data reliability when saving data in a mysql database?
> 
> Also, do you happen to know a difftool for xml files that runs faster than xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I have lying around, and it is still running for the last hour or so.
> 

Jacob,

The list of open SQL backend bugs is https://bugs.gnucash.org/buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=NEEDINFO&bug_status=REOPENED&component=Backend%20-%20SQL&list_id=3199&query_format=advanced. AFAICT none affect data integrity.

Regards,
John Ralls




More information about the gnucash-user mailing list