Any prognosis for when 2.4 is due?

Phil Longstaff plongstaff at rogers.com
Fri Jan 1 11:10:42 EST 2010


On Thu, 2009-12-31 at 20:28 -0800, Don Quixote de la Mancha wrote:
> Will the SQL backend make GnuCash data fault-tolerant?
> 
> In general, MySQL and PostgreSQL are fault-tolerant, in that the
> database integrity will be maintained if there is a crash or power
> failure.
> 
> For this to work with application data, one needs to also use
> Commit/Rollback, where updates to the database might be made with a
> sequence of SQL queries.  When they have all succeeded, then one
> Commits the entire sequence atomically.  If there is some problem
> while building the transaction, then one can Rollback, and no change
> is made to the database at all.
> 
> I have always been uncomfortable with the fact that GnuCash file data
> is held in memory while in use, with (in my understanding) the entire
> file being written out when one finally saves.
> 
> Of course the xac and log files go a long ways towards preventing
> trouble - but couldn't possibly be as effective as the fault tolerant
> provided by a good database backend.

Commit/Rollback are used.  There are some places that still need some
work.  For example, when a transaction with 2 splits is saved, the
transaction and splits are saved in separate db transactions.  I don't
know if this one will be fixed for 2.4 or will wait for 2.4.1.

Phil



More information about the gnucash-user mailing list