The official SQLite Encryption Extension does not support encrypting in-memory databases per their documentation: https://www.sqlite.org/see/doc/trunk/www/readme.wiki
Limitations
- TEMP tables are not encrypted.
- In-memory (":memory:") databases are not encrypted.
- Bytes 16 through 23 of the database file contain header information which is not encrypted.
Does SQLCipher have these same limitations?