[GNC] XML vs SQL data integrity question

[D.]

My experience matches David H. Windows 10, dropbox XML file. No crashes in years. Might want to figure out why Windows is hiccuping, rather than change data back ends. I can't imagine that recovering your corrupted gnucash data will be easier with an SQL back end. 

David T. 


-------- Original Message --------
From: David H <hellvee at gmail.com>
Sent: Thu May 07 12:06:28 GMT+05:30 2020
To: Jeff <beastmaster126 at hotmail.com>
Cc: Gnucash userlist <gnucash-user at gnucash.org>
Subject: Re: [GNC] XML vs SQL data integrity question

I've only ever used the default compressed xml backend with gnucash on Win
10 Pro.  Been using it since about 2010 and never had an issue - always
update to the latest version as soon as it comes out.  Running on MacOS
Catalina, Win 10 Pro and Ubuntu 20.04 now, sharing file via freefilesync
and dropbox.  Dunno what you're doing to corrupt your file and make Win 10
kill gnucash, I've never had issues with Win 10 killing gnucash...

Cheers David H.


On Thu, 7 May 2020 at 15:09, Jeff <beastmaster126 at hotmail.com> wrote:

> This has probably been discussed here before but; I'm going ask anyway.
> Which do most people find more reliable with GNC, SQL or the default
> XML?  And are there any features I would lose other than the rollback
> ability with SQL?
>
> I'm getting tired of having to track down account and report issues
> every time Windoze 10 hiccups.  I use the default XML, uncompressed.
> One set of books has been corrupted several times, I'm assuming when
> Windoze just simply kills the GNC program out of the blue.  I have
> another set of books for a business that so far, knock on wood,  the
> only problem is sometimes various buttons have to be selected multiple
> times to work then all of the windows open in GNC blur while processing
> then go back to normal display.
>
> My computers are all networked and dual boot Windoze and Ubuntu, so I
> would need SQL on both sides if I switch over.  I'm leaning towards
> PostgreSQL (pro's, con's?  Suggestions?).
>
> --
> --JEffrey Black M.B.A.
>
> _______________________________________________
> 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.
>
_______________________________________________
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.