[GNC] Database storage

[Robert Heller]

It should be noted: GnuCash does *not* do database queries as it processes 
transactions.  It copies the whole "database" to memory at start and writes 
the whole in-memory database out when it "saves".  Using a database system is 
not any different than using a XML file on a shared file system.  You cannot 
run two instances of GnuCash using the same file OR database.  At least not as 
GnuCash is currently implemented.  The only thing a PostgreSQL or MySQL 
database gives you is a different way of accessing GnuCash's data *between* 
runs of GnuCash.  That is using other programs to extract data outside of 
GnuCash.

At Wed, 18 Sep 2024 18:32:19 -0700 (PDT) Chris Miller <cjm at tryx.org> wrote:

> 
> Hi Folks, 
> 
> The FAQ talks about PostgreSQL storage and how it was tired and discontinued, but then tried again. This was around version 2 - 3. We are now at version 5.8. 
> 
> Is there support for database storage? I see reference to sqlite3, PostgreSQL, and MySQL. Sqlite3 is obviously supported, since I can simply save my content as sqlite3 in preference to XML, but I'd really like to use either PostgreSQL or MySQL, because, that makes GnuCash client server, and probably lets me run on distributed client machines. If GnuCash can communicate with a database, it probably doesn't matter where the database is. 
> 
> What is the authoritative position for configuring database storage? Where are the instructions about how to do it? 
> 
> Thanks for the help, 

-- 
Robert Heller             -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software        -- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
heller at deepsoft.com       -- Webhosting Services