[GNC] XML vs SQL data integrity question

[David Cousens]

Stu

Have you trie Unison File synchronizer (https://www.cis.upenn.edu/~bcpierce/unison/) to synchronize the user stored
data. Runs on UniX Windows MacOSX and uses SSH. It can be run with  a cron job on Linux or scheduled in Windows to keep
machines on a network synchronized. I only run it manually but it keeps all my userfiles synched onseveral unixboxes and
selected files to a Windows 10.

David Cousens




On Thu, 2020-05-07 at 11:37 -0400, Stu Perlman wrote:
> I'm running MySQL for a GNC backend.  I switched about 4 months ago.  So
> far, so good and I love the ability to have direct access to mostly
> normalized data whenever I want.
> Every so often, if I leave my computer idle for a long time I'll get a
> failed to save to database error if GNC was left running - but that's my
> only complaint.
> 
> I am running GNC and MySQL on my Windows 10 system.  I recently set up an
> Ubuntu system to see if I like that better than Windows for a personal
> computer.  I have been able to access the GNC db from Ubuntu across my
> home network, again trouble-free.  Running GNC on either Windows or Ubuntu
> has been seamless as far as the data goes.  If I were going to keep both
> environments around for the long term, I would probably want to figure out
> how to share the non-database stuff between the two such as saved report
> configurations, preferences, etc ...
> 
> Good luck!
> 
> On Thu, May 7, 2020 at 1:10 AM 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.
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed