[GNC] tutorials or examples for connecting/programming for GnuCash data access

[john]

Please remember to copy the list on all replies.

While providing a stable library for other applications to use is a long-term goal we've still got a fair amount of work to do before we can support it. Until then we make absolutely no API or ABI stability guarantees for the shared libraries: On the contrary, we plan extensive API changes and internal redesigns that will substantially affect ABI as well.

Because of the long-standing ability to write custom reports in Guile we will mark as deprecated changes in the Scheme API, including wrapped C/C++ functions. Deprecated functions will be removed at the subsequent major release, meaning that any Scheme function that raises a deprecation warning in 4.x will be removed in 5.0. No such warnings will be made for C/C++ API nor for the Python bindings.

Regards,
John Ralls


> On Jul 26, 2022, at 7:13 AM, Esteban Maringolo <emaringolo at gmail.com> wrote:
> 
> I'm interested in this as well...
> 
> Being able to use GNUCash as an "accounting engine" for other software
> would be a great feature.
> 
> The only thing I found was PieCash [1], but it seems to write directly
> to the database and not by calling internal functions/shared libraries
> of GnuCash.
> 
> Regards,
> 
> [1] https://github.com/sdementen/piecash
> 
> Esteban A. Maringolo
> 
> On Mon, Jul 25, 2022 at 3:08 PM john <jralls at ceridwen.us> wrote:
>> 
>> 
>> 
>>> On Jul 25, 2022, at 9:30 AM, Eric Hammond <eric at jehammond.net> wrote:
>>> 
>>> Are there tutorial examples / videos for using Python and/or Sqlite3 to work with GnuCash.
>>> I have never used Sqlite, and my Python experience is mostly industrial, and outdated.
>>> (Like, what are bindings?)
>> 
>> Google found no GnuCash programming tutorials, though it did find some Piecash ones.
>> 
>> There's https://wiki.gnucash.org/wiki/SQL-Requests_For_Direct_Database_Access for SQL. It's not specifically about SQLite3 but you can read their docs for using the command-line tool.
>> Bindings are wrapper functions, in our case created by SWIG, that translate between e.g. Python and the C/C++ in which the GnuCash engine is written.
>> There's some information in https://wiki.gnucash.org/wiki/Python_Bindings and a brief mention in https://www.gnucash.org/docs/v4/C/gnucash-guide/ch_python_bindings.html. There are some examples in https://github.com/Gnucash/gnucash/tree/maint/bindings/python/example_scripts.
>> 
>> 
>> Regards,
>> John Ralls
>> 
>> _______________________________________________
>> 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
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.