[GNC] XML vs SQL data integrity question

[Stu Perlman]

Thanks for this tip, David.

I'll check it out.  It might be easier than trying to run everything from a
shared storage location.

- Stu

On Thu, May 7, 2020 at 5:32 PM David Cousens <davidcousens at bigpond.com>
wrote:

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