Page 1 of 1

Temp tables encrypted?

Posted: Thu Mar 22, 2018 9:41 pm
by fried green okra
does wxSQLLite3 encryption have the same limitations as the official sqllite encryption extension, which states that it does not encrypt temp tables?

Re: Temp tables encrypted?

Posted: Fri Mar 23, 2018 8:05 am
by utelle
fried green okra wrote:does wxSQLLite3 encryption have the same limitations as the official sqllite encryption extension, which states that it does not encrypt temp tables?
Yes. wxSQLite3 has the same limitations as listed at the bottom of the SEE documentation page. The reason is that this is a limitation of the SQLite encryption API used by wxSQLite3.

BTW, this is true for all encryption extensions using the (unmodified) encryption API of SQLite, like for example SQLCipher.

If your application has to use temporary tables, you should then use

Code: Select all

PRAGMA temp_store=2;
to store temporary tables in memory instead of in a file.

Regards,

Ulrich

Re: Temp tables encrypted?

Posted: Mon Mar 26, 2018 6:56 pm
by fried green okra
Great. The in memory temp table is a perfect solution.

Thanks!

Casey