Everyone in this thread should read https://wiki.gnucash.org/wiki/FAQ#SQL_Database
It explains many points regarding gnucash and its implementations of the database back end. It explains the dbms that are supported (postgresql is among them) as well as the limitations to the current implementation. -------- Original Message -------- From: Jean-David Beyer via gnucash-user <[email protected]> Sent: Thu Nov 25 07:23:05 EST 2021 To: [email protected] Subject: Re: [GNC] Using Gnucash to access file over flaky network On 11/25/21 04:47, Geoff wrote: > Hi Chris > > In my opinion this is really an SQLite question, not a GnuCash question. > > To quote the SQLite dev team:- > "Rely upon it at your (and your customers') peril. See How To Corrupt > Your Database Files. > > Choose the technology that is right for you and your customers. If your > data lives on a different machine from your application, then you should > consider a client/server database. SQLite is designed for situations > where the data and application coexist on the same machine. SQLite can > still be made to work in many remote database situations, but a > client/server solution will usually work better in that scenario." > > https://www.sqlite.org/draft/useovernet.html > > > Good luck! > > Regards > > Geoff I do not know if Gnucash can run with postgreSQL, but if it can, perhaps that would be a better relational dbms to use? -- .~. Jean-David Beyer /V\ Shrewsbury, New Jersey /( )\ Red Hat Enterprise Linux ^^-^^ up 4 days, 22 hours, 58 minutes _______________________________________________ gnucash-user mailing list [email protected] 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. _______________________________________________ gnucash-user mailing list [email protected] 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.
