[GNC] Database storage

[Mark Penner]

Sep 20, 2024 03:51:56 Jim DeLaHunt <list+gnucash at jdlh.com>:

> Then when you tell GnuCash to store a single "accounting record of an exchange of value" entry, GnuCash updates the data it has in memory. In simple terms, it does not make any change to data stored in the database at that moment.  When you tell GnuCash to save the book, then it makes a few controlled and reliable changes to data stored in a database so that the information in memory is stored in the database.

When I was using the SQLite backend, it wrote the changes immediately, I didn't save manually. The save action may have been greyed out, I can't remember. SQLite isn't designed for concurrent writes, though.

I'm not sure how reading a SQLite db is handled, that may still be done only at startup.

I haven't looked at the code, I'm relying on my memory of how the UI showed things.