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 <c...@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 hel...@deepsoft.com -- Webhosting Services _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
