I would like to add a question to Tom's list. Is there any way to easily make periodic backups of SQLite data files?
On Tue, Apr 19, 2022 at 8:21 PM Derek Atkins <de...@ihtfp.com> wrote: > Hi, > > On Tue, April 19, 2022 7:55 pm, Tom Browder wrote: > > 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?" > > Sure, tell it to do that. It only adds ".gnucash" by default, but it > won't override what you tell it. > > > 2. Is there any hope of some kind of "commit" button to use with the > > SQLite > > version? > > The benefit of the SQL backend is that it writes all changes when you > commit (enter) a transaction. So no, there will not be a "Save" button. > The "commit" button is the "Enter" key (or exiting out of a transaction > edit). > > > 3. I assume the binary SQLite file is usable with a binary copy from > > Windows, is that true? > > I'm not sure I understand this question, but the SQLite data file is > usable from any platform. > > > 4. Is there any Perl program on Windows to convert the xml file to > SQLite? > > Is there one on Linux? > > No. Open the XML in GnuCash and then File -> Save As to save it as SQLite. > > > 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. > > You mean without using File -> Save As? > > > 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. > > Yes, you may be able to use the Python bindings to open the XML file and > SaveAs SQL. I've never tried it. > > > Thanks for any help or suggestions. > > > > -Tom > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. > -- David Carlson _______________________________________________ gnucash-user mailing list gnucash-user@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.