[GNC] Using a mysql database?

[Joseph Vernice]

Been using MySQL DB for gnu cash for many years, mainly because of
security. Never had a problem. Very reliable and fast on my lan server.
Not sure how fast over internet.


On Tue, Mar 12, 2019 at 7:37 PM John Ralls <jralls at ceridwen.us> wrote:

>
>
> > 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
>
>
> _______________________________________________
> 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.
>