Re: [sqlite] EncFs + sqlite3

2013-09-23 Thread Clemens Ladisch
Paolo Bolzoni wrote: > What do you mean with "if you do not ATTTACH databases"? EncFS does not implement .fsyncdir, which is used by SQLite when deleting the master journal file. Such a file is used for transactions when there are multiple database files, i.e., when you have used ATTACH. But I

Re: [sqlite] EncFs + sqlite3

2013-09-23 Thread Paolo Bolzoni
What do you mean with "if you do not ATTTACH databases"? I should not use the ATTACH DATABASE command to add a second database to a connection or I cannot use a db at all? On Mon, Sep 23, 2013 at 3:43 PM, Clemens Ladisch wrote: > Paolo Bolzoni wrote: >> I was wondering, is

Re: [sqlite] EncFs + sqlite3

2013-09-23 Thread Clemens Ladisch
Paolo Bolzoni wrote: > I was wondering, is using sqlite3 under EncFs safe? > For "safe" I mean is the db is strong against data corruption > as in a usual filesystem? EncFS implements the .fsync callback but not .fsyncdir, so the deletion of the master journal is not synchronized, so your data

[sqlite] EncFs + sqlite3

2013-09-23 Thread Paolo Bolzoni
Dear list, I was wondering, is using sqlite3 under EncFs safe? For "safe" I mean is the db is strong against data corruption as in a usual filesystem? Do anyone has experience? It would be reasonably easy to test? Your faithfully, Paolo ___