Intermediate results may be written into a temp file, if they overflow memory. This could result in an information leak, yes. On the other hand, if you set SQLITE_TEMP_STORE=2 so that intermediate results are held in memory, then intermediate results may be written to swap space when the device gets under memory pressure. So, I'm not sure it makes that much difference. I kind of suspect that a explicit TEMP file would be safer, as it seems to me it will be harder to find forensic traces of a TEMP file amid the clutter of a massive volume, and TEMP files are likely to be overwritten quickly, which I'm not sure happens with the swap file. But maybe a security geek can correct me on this. And maybe it depends a lot on what OS you are running, or what version of that OS, or how you have the system configured.
So it is hard to know what the right thing to do is. On 1/28/19, Jim Borden <jim.bor...@couchbase.com> wrote: > Having moved from SQLCipher to SEE some time ago, the old advice that > SQLCipher gave has stuck with me (from > https://www.zetetic.net/sqlcipher/design/ in the Database Encryption and > Temporary Files section): “Provided that you taken the important step of > disabling file base temporary stores (i.e. --enable-tempstore=yes during > configuration and define SQLITE_TEMP_STORE=2 during build)” > > The reasoning behind this is that certain temporary files are not encrypted > when being written and thus are a violation of the security provided by > encryption of the database. I couldn’t find any equivalent warnings > regarding SQLite Encryption Extension (or anything to assure me that this > was *not* the case with SEE) so I thought I would ask here if the same > advice applies or can we be assured that anything SQLite with SEE writes to > the disk relating to the encrypted database will also be encrypted? > > <superfluous background (not required reading)> > The reason why I ask this is because there is a debate going on about the > appropriate setting of SQLITE_TEMP_STORE on mobile devices and whether or > not it will end up using too much memory and getting an application > terminated. However, the above advice would pretty much force our hand on > the version of our product that uses SEE. > </superfluous background> > > Thanks, > Jim Borden > > > > Privacy Policy<http://www.couchbase.com/privacy-policy> > Marketing > Preferences<http://info.couchbase.com/unsubscribe-or-manage-preferences> > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users