Temp tables encrypted?

In this forum you can discuss database related issues which can be wxWidgets related, but also generic in nature.
Post Reply
fried green okra
In need of some credit
In need of some credit
Posts: 2
Joined: Thu Mar 22, 2018 9:36 pm

Temp tables encrypted?

Post 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?
utelle
Moderator
Moderator
Posts: 1125
Joined: Tue Jul 05, 2005 10:00 pm
Location: Cologne, Germany
Contact:

Re: Temp tables encrypted?

Post 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
fried green okra
In need of some credit
In need of some credit
Posts: 2
Joined: Thu Mar 22, 2018 9:36 pm

Re: Temp tables encrypted?

Post by fried green okra »

Great. The in memory temp table is a perfect solution.

Thanks!

Casey
Post Reply