Any differences in choosing MySql vrs XML file?

[Derek Atkins]

Keith Bellairs <keith at bellairs.org> writes:

> Use of a database allows you to make use of the database's security. This
> can give you password protection of data. The quality of the security then
> depends on the dbms and not on gnucash (though your data will still be in
> memory when the application is running, if you are really paranoid).

This can be either a plus or a minus.

Are you sure your connection to the database is using SSL?
If it is not, then all your data is going over the network in the clear.

Who has access to the database, and how is that any different to the
question of who has access to your file system?  You DO use different
user accounts locally, don't you?  Why would you trust the root account
on the db server any more than you would trust the root account on your
desktop computer?

> Use of a database complicates keeping of a backup. Backing up a mysql db is
> not the same as making a copy of an XML file.
>
> None of this helps with trying to make gnucash a multi-user application.

Agreed.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available