On 2/12/18, crest iOS <crestiost...@gmail.com> wrote:
> Hi Sir,
> I want to know that Table-Level Encryption is possible in SQLite or not.

The SQLite Encryption Extension [1] encrypts an entire database.
There is no option to encryption some tables and not others.  This is
because SEE operates at the pager layer and the pager does not know
what table a particular page belongs to.

But what you can do is separate your data into two separate database
files.  One file is encrypted and the other is not.  Then open your
database connection on the unencrypted file and ATTACH the encrypted
file, or vice versa.  SQLite does allow connections where there are
multiple attached databases, some of which are encrypted and others

[1] https://www.hwaci.com/sw/sqlite/see.html

D. Richard Hipp
sqlite-users mailing list

Reply via email to