[GNC] New to GnuCash SQLite on Windows: I have questions

Tom Browder tom.browder at gmail.com
Tue Apr 19 19:55:54 EDT 2022


I just updated my MS Windows GnuCash version to 4.10 and see the new option
to save my GnuCash xml file in SQLite format. In general, I like it!

However, I had a few moments of panic when Windows wanted to save the file
without a name change.  I also forgot the changes in the SQLite file are
done without notice.
(When I first started withGnuCash on Windows, I was able to unzip the xml
file and save it unzipped as "myGnuCash.gnucash" successfully so I get
version control over a text file for readable diffs.)

1. Is there any way to get GnuCash to save its file, by default, with an
appropriate suffix other than "gnucash?"

2. Is there any hope of some kind of "commit" button to use with the SQLite
version?

3. I assume the binary SQLite file is usable with a binary copy from
Windows, is that true?

4. Is there any Perl program on Windows to convert the xml file to SQLite?
Is there one on Linux?

My immediate goal is to continue using my xml fille on Windows as the
master data source until I'm comfortable with the SQLite version. During
that time, I will periodically produce an SQLite version as a read-only one
to experiment with on Linux.

I would love to do that automatically.

I have briefly looked at the (ugh) Python support and may go down that
route, but not until I've looked at compiling from github on Linux and
looked at what's available.

Thanks for any help or suggestions.

-Tom


More information about the gnucash-user mailing list