[sqlite] SEE extension questions

2019-05-26 Thread Karl Sanders
Hi, I'd like to ask a few questions about the SEE extension. - Are tables (virtual and real) used by the various extensions (in particular by the FTS5 and R*Tree modules) encrypted? - Are there any pragmas or compile-time options that don't work with encryption? - Is there any functionality

[sqlite] Questions about SQLite Encryption Extension (SEE)

2017-06-08 Thread Karl Sanders
I would like to know if an encrypted database allows hot backups and page sizes different from the default one. Is encryption applied to everything that gets written to disk? Including transient indices and materializations of views and subqueries? Regards, Karl