[GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

[Kalpesh Patel]

IMHO, that is probably asking too much from a person that has never put a foot in the software development world. Let's keep the "customers" in mind as to who they are. 

While I completely agree that SQL backend does have many benefits, if one was dive in without understanding it, it is more likely to make the situation worse rather than make it  better. Especially if things in the database go south. 

-----Original Message-----
From: John Ralls <jralls at ceridwen.us> 
Sent: Monday, September 09, 2024 1:27 PM
To: David G. Pickett <dgpickett at aol.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

That said, if you use the SQL backend with a server, i.e. mariadb/mysql or Postgres, you get password protection and database locking with much less latency than any file-sharing mashup provides. You do need to learn about the care and feeding of the server including ensuring that it’s secure if it’s exposed to the Internet, configuring users, and arranging for backups.

Regards,
John Ralls


> On Sep 9, 2024, at 07:16, Derek Atkins <derek at ihtfp.com> wrote:
> 
> The GnuCash team, historically, have explicitly decided that GnuCash 
> leave encryption and other password protection to external tools and 
> NOT perform it internally.  GnuCash is a financial tool, not a security tool.
> 
> -derek
> 
> On Mon, September 9, 2024 9:59 am, David G. Pickett via gnucash-user wrote:
>> The security concerns beg the question, should GnuCash files be 
>> password protected by the app?  It'd slow save and open a bit, but 
>> then you are less worried about the files being snooped.
>> 
>> There are also ways to encrypt local files, and back up the encrypted 
>> files to you network drive.  Just make sure you do not lose the password!
>> _______________________________________________
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
> 
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.