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 <[email protected]> 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 > [email protected] > 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 [email protected] 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.
