Thank you, that's very helpful.
I was more wondering how close to useful AI now is answering arbitrary
questions like this, rather than any specific interest in Piecash or
SQLAlchemy. I really only chose Gnucash as the data source for the
experiment because I had lots of data handy.
In one of Arthur C Clarke's books, I think Imperial Earth, a character
casually poses a pentaminos question to a computer terminal, which
writes and runs a suitable algorithm in seconds. I wondered how close we
now were to this dream (nightmare?).
FWIW Gemini also suggested an SQL Query to answer the question, which
worked perfectly immediately.
I conclude that it's nearly there, but it's still simpler to use
tried-and-true (possibly more manual) techniques for many such ad hoc
questions.
Thanks again, Paul
On 2026-11-03 2:35 a.m., Wm Tarr wrote:
There are a number of layers here.
The warning is from SQLAlchemy which piecash uses, you should ask the
current maintainers of piecash about that rather than here.
Further, if you want to use AI to interact with a gnucash book why
don't you try something like
ninetails-io/gnucash-mcp: MCP server enabling AI assistants to read
and write GnuCash accounting data
<https://github.com/ninetails-io/gnucash-mcp>
where someone else has already done all the hard work, I've been
playing with it myself (on a copy of my main book) and I like it.
Wm
_______________________________________________
gnucash-user mailing list
[email protected]
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.
