In addition to what R Losey mentioned, I'll add that while GnuCash can
use MySQL, Postgres, or SQLite as an optional backend, it is not yet a
true db application. For now, that is just a storage mechanism.
Everything is loaded into RAM and edited from there.
The advantage to the SQL backends (other than outside queries if you so
desire) is instant saves, where the default XML backend either needs to
be saved manually, or at set intervals. (the default)
One other caveat - writing to the db store is not currently supported.
It isn't that you can't at all, but you are warned and on your own if
you corrupt your data. Some folks may report success here, but don't
just jump in and start editing data via SQL willy-nilly. (reading is fine)
You can check out the Roadmap on the wiki to see the progress done on
the code transformation that will enable a proper db-based app.
As for the banking connection - sorry I can't help, but plenty of folks
on this list do, so they can hopefully jump in and offer some guidance.
(if I understand it correctly, you will not be able to 'initiate' a
transaction directly from GnuCash to your bank, you will only be able to
download transactions, and there are other options than a direct
connection.)
As for OS, I use Mac daily, but occasionally test on Linux. (Ubuntu) I
used to do that via builds if needed, and I've had a few hiccups, but
those were mostly resolved. I've since resorted to testing flatpak
builds (on Mint) without any major issues. Your mileage may vary.
Regards,
Adrien
On 7/25/23 3:15 PM, Ben Kamen wrote:
I really dig the idea that GnuCash can use MySQL and might set that up
once I get used to GnuCash.
And while I have a super basic setup configured, the first thing I'd
like to test out is my banking connection.
_______________________________________________
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.
