Re: [GNC] XML vs SQL data integrity question

Jeff, When you get the time, you might try this: Save the xml file twice in each data format (or at least those that work). If the two saved files in the same format are identical in size, you have a high probability that GnuCash consistently wrote the data. You won't be 100% sure if that was

Re: [GNC] XML vs SQL data integrity question

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 wrote: > Stu > > Have you trie Unison File synchronizer ( > https://www.cis.upenn.edu/~bcpierce/unison/) to

Re: [GNC] XML vs SQL data integrity question

On 5/8/2020 2:03 AM, GWB wrote: Have you tried sqlite? I don't know how it works on Windows but it might just save it as a file without setting up a salute back end. Maybe try that when you have time. Gordon On Fri, May 8, 2020, 1:27 AM Jeff > wrote:

Re: [GNC] XML vs SQL data integrity question

Have you tried sqlite? I don't know how it works on Windows but it might just save it as a file without setting up a salute back end. Maybe try that when you have time. Gordon On Fri, May 8, 2020, 1:27 AM Jeff wrote: > On 5/7/2020 8:28 PM, GWB wrote: > > The idea about the images is a very

Re: [GNC] XML vs SQL data integrity question

On 5/7/2020 8:28 PM, GWB wrote: The idea about the images is a very good one. Invoices, receipts, etc., would do fine in digital format. No question that databases are capable of much greater depth, granularity and ability to search and change. However, in defense of the humble xml text file,

Re: [GNC] XML vs SQL data integrity question

The idea about the images is a very good one. Invoices, receipts, etc., would do fine in digital format. No question that databases are capable of much greater depth, granularity and ability to search and change. However, in defense of the humble xml text file, I give you this: cat

Re: [GNC] XML vs SQL data integrity question

On 5/7/2020 11:18 AM, Gregory Gincley wrote: Sounds like you have a couple of issues happening there. I have no experience with Windows, but I've used the postgres backend in linux for many years without issue. I also periodically save to the XML format as a backup. -Greg On Thu, 2020-05-07

Re: [GNC] XML vs SQL data integrity question

Have used sqlite3, postgresql, and xml on various machines (Windows 7, Ubuntu, FreeBSD). Windows 7 (with extended service for malware) does fine with xml, but I have not had a problem with the sql backends. sqlite was easier to set up as a backend than postgres, but postgres (from other uses as a

Re: [GNC] XML vs SQL data integrity question

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

Re: [GNC] XML vs SQL data integrity question

I use Ubuntu with Postgresql, saving sometimes to XML. Had a lot of troubles in Windows with XML. > > On May 7, 2020 at 19:21, mailto:rollenwi...@fastmail.net)> > wrote: > > > > Sounds like you have a couple of issues happening there. I have no > experience

Re: [GNC] XML vs SQL data integrity question

I used XML with Ubuntu for a few years then switched to SQLite. I rarely ever closed GC. Then I switched to Mac as my daily driver and I kept using SQLite but occasionally test XML for a spell if I’m trying to repeat a bug and rule out my backend choice. Over those 9-10 years, I think I’ve

Re: [GNC] XML vs SQL data integrity question

Sounds like you have a couple of issues happening there. I have no experience with Windows, but I've used the postgres backend in linux for many years without issue. I also periodically save to the XML format as a backup. -Greg On Thu, 2020-05-07 at 00:07 -0500, Jeff wrote: > This has

Re: [GNC] XML vs SQL data integrity question

On 5/6/20 10:07 PM, Jeff 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

Re: [GNC] XML vs SQL data integrity question

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

Re: [GNC] XML vs SQL data integrity question

. Original Message From: David H Sent: Thu May 07 12:06:28 GMT+05:30 2020 To: Jeff Cc: Gnucash userlist 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

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

[GNC] XML vs SQL data integrity question

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