[GNC] Database backend for gnucash?

Derek Atkins derek at ihtfp.com
Wed Oct 9 20:58:54 EDT 2024


That presupppses you have the correct libdbi DBD backend drivers installed.
-derek
Sent using my mobile device. Please excuse any typos.
On October 9, 2024 20:36:41 William Prescott <will at theprescotts.com> wrote:

> 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.
>
> _______________________________________________
> 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.



More information about the gnucash-user mailing list