[Kmymoney-devel] Advantages to saving file as database

[Randy Lutzinger]

On 10/30/2011 05:44 AM, Tony Bloomfield wrote:
> On Sat, 29 Oct 2011 11:37:45 -0400
> Randy Lutzinger<rlutzinger at comcast.net>  wrote:
>
>> I know that we are also able to save the file as a database. Does
>> saving the file as a database offer any advantages over using the
>> standard file format? Does encryption still work when saved as a
>> database?
> The main advantage of the database format is that you could create
> different views into your data using a product such as LibreOffice. You
> can go further if you have any knowledge of the SQL language used with
> relational databases.
>
> There is currently no encryption of the database itself. What I do is
> dump the DB to a file and encrypt that, then delete the DB. When I next
> need it, I decrypt and reload. If you're going to use Mysql, there is a
> script available under kmymoney/contrib/mysqlcrypt.sh which you may find
> useful.
>
>
Thanks for the information. I think at this time I'll just stick with 
using the default file format and not the database format. I like the 
fact that the file is encrypted automatically for me when I close the 
program.

Randy