Temp tables encrypted?
-
- In need of some credit
- Posts: 2
- Joined: Thu Mar 22, 2018 9:36 pm
Temp tables encrypted?
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?
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.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?
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;
Regards,
Ulrich
-
- In need of some credit
- Posts: 2
- Joined: Thu Mar 22, 2018 9:36 pm
Re: Temp tables encrypted?
Great. The in memory temp table is a perfect solution.
Thanks!
Casey
Thanks!
Casey