Re: [GNC] .log files with sqlite backend

2018-04-20 Thread cicko
Geert Janssens-4 wrote > The save button is permanently disabled when using an sql based book. > >> So, from what I understand, the whole point of .log files is to help >> prevent >> losing changes if there's a crash before the user clicks Save with an xml >> book? >> > Yes. Oh, OK. So the Save

Re: [GNC] .log files with sqlite backend

2018-04-19 Thread Geert Janssens
n.sil...@gmx.com" <alen.sil...@gmx.com>, "sunfis...@yahoo.com" > > <sunfis...@yahoo.com> Subject: Re: [GNC] .log files with sqlite backend > > > > So I don't see why you would want or need to replay logs with SQL. > > Is there a specific use-case her

Re: [GNC] .log files with sqlite backend

2018-04-19 Thread Alen Siljak
> Sent: Thursday, April 19, 2018 at 3:47 PM > From: "Derek Atkins" <warl...@mit.edu> > To: "David T. via gnucash-user" <gnucash-user@gnucash.org> > Cc: "alen.sil...@gmx.com" <alen.sil...@gmx.com>, "sunfis...@yahoo.com" >

Re: [GNC] .log files with sqlite backend

2018-04-19 Thread Derek Atkins
Hi, "David T. via gnucash-user" writes: > Alen, > I think you have identified a potentially significant issue with log > files and sql data files.  Specifically, with xml files, full > snapshots are saved periodically, and log files are paired with these > snapshots to

Re: [GNC] .log files with sqlite backend

2018-04-18 Thread David T. via gnucash-user
Alen, I think you have identified a potentially significant issue with log files and sql data files.  Specifically, with xml files, full snapshots are saved periodically, and log files are paired with these snapshots to enable a user to "replay" actions to recover a previous state.  It is

Re: [GNC] .log files with sqlite backend

2018-04-18 Thread cicko
John Ralls-2 wrote > With a database, including a SQLite3 file, the storage is under the > control of the database engine. In order for GnuCash to make a backup it > would need to explicitly copy the SQLite3 file; even that wouldn’t > necessarily be possible for a MySQL or Postgresql database.

Re: [GNC] .log files with sqlite backend

2018-04-18 Thread John Ralls
> On Apr 18, 2018, at 12:12 AM, cicko wrote: > > While I was using xml backend in the past couple of weeks, I finally realized > how backup files and .log files work. I really like the scheme as, before > that, I had a script that creates backups of sqlite book in the same

Re: [GNC] .log files with sqlite backend

2018-04-18 Thread Colin Law
On 18 April 2018 at 08:12, cicko wrote: > While I was using xml backend in the past couple of weeks, I finally > realized > how backup files and .log files work. I really like the scheme as, before > that, I had a script that creates backups of sqlite book in the same manner

[GNC] .log files with sqlite backend

2018-04-18 Thread cicko
While I was using xml backend in the past couple of weeks, I finally realized how backup files and .log files work. I really like the scheme as, before that, I had a script that creates backups of sqlite book in the same manner (and deletes the .log files). Now, back to using sqlite book, I