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 not. [1] https://www.hwaci.com/sw/sqlite/see.html -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users