[GNC] GnuCash preferred OS - Windows or Linux

[Adrien Monteleone]

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.