Unlike —real— databases, SQLite files are just ordinary files. You can copy and move them like any other file. So they can be backed up with a simple copy.
Will On 2022 Apr 19, at 04-19 22:59:04, David Carlson <david.carlson....@gmail.com> wrote: 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. _______________________________________________ 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.