[GNC] Database storage

[Roberts K]

In my experience the amount of data is relatively small (even for thousands
of records) and database performs well in XML form. As other people have
said - it is copied into memory, So not much use putting it on proper
RDBMS. I remember when I used it on MySQL over 100Mb connection on LAN (or
even MySQL on the same laptop) there was a distinct lag in importing
several hundred transactions, which was not there with XML or SQLite
backend.

I found the best of both worlds is to use SQLite backend - because it is
fastest and most portable - you just need to copy the file. It allows me to
run quite complex reports from R using standard SQL approach. Even more - I
made some bash scripts with SQL queries utilizing regexp support, that
allowed me to quickly get some vital information on terminal - even without
firing up gnucash.

Best wishes,
Roberts
--
Dr Roberts Klotins



On Thu, 19 Sept 2024 at 02:33, Chris Miller via gnucash-user <
gnucash-user at gnucash.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,
> --
> Chris.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>