[GNC] XML vs SQL data integrity question
Stu Perlman
sgperlman at gmail.com
Thu May 7 11:37:05 EDT 2020
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.
>
More information about the gnucash-user
mailing list