Temp tables encrypted?

In this forum you can discuss database related issues which can be wxWidgets related, but also generic in nature.
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?

Postby fried green okra » Thu Mar 22, 2018 9:41 pm

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: 830
Joined: Tue Jul 05, 2005 10:00 pm
Location: Cologne, Germany
Contact:

Re: Temp tables encrypted?

Postby utelle » Fri Mar 23, 2018 8:05 am

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?

Postby fried green okra » Mon Mar 26, 2018 6:56 pm

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

Thanks!

Casey


Return to “Database Related”

Who is online

Users browsing this forum: No registered users and 1 guest