I have been using GnuCash with a MySQL database. I used it for the
ability to replicate to an offsite backup/slave.
That feature has saved me a number of times.
Local LAN is very fast. Even over a slow WAN connection it's pretty fast
as long as I keep the Database limited to about a year.
If I kept more then 3 years of moderate personal use, then it would
start to slow down but not badly.
On 2019-03-12 20:14, Joseph Vernice wrote:
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 <jra...@ceridwen.us> wrote:
> On Mar 12, 2019, at 3:39 PM, Jacob Larsen <ja...@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@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.
