[GNC] Database backend for gnucash?

[William Prescott]

When one Saves As ..., there is a choice to save as: xml, sqlite3, postgres or mysql.

Best wishes,
Will

On 9 Oct 2024, at 15:22, Mark at Lorimark <mark at lorimarksolutions.com> wrote:

Hi Gere,

The back-end is simply "sqlite".  If you can get that installed, then you can open the gnucash.sqlite files directly and poke around in them. The flat structure is pretty simple, does not rely heavily on RDBMS.

Here is one reference in the gnucash docs;

> https://wiki.gnucash.org/wiki/SQL

Additionally, I have some notes and references on the back-end regarding structures and things as well, if you're interested, as I too am building external apps to poke around in the gnucash.
~mark petryk
~w:http://www.lorimarksolutions.com

On 10/9/24 16:06, Gere Kiss Zsolt wrote:
> Hi all,
> I've been using Gnucash for some good years now and noticed that it saves
> its data in .gnucash files, which are gzip compressed XML data. Recently,
> wanted to automate some tasks I see that many apps have been written to
> leverage Gnucash, by using its database back-ends! (for example [Gnucash
> Rest](https://github.com/loftx/gnucash-rest/blob/master/README.md), and
> many others). How can I install/ make use of such a back-end for the app? I
> am nowhere seeing this option on the Gnucash pages.
> Many thanks,
>     Zsolt
> ---------------------------------------------------------------------------------------------------
> „We have two lives, and the second begins when we realize we only have one.”
> -- Confucius
> _______________________________________________
> 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.
_______________________________________________
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.