> On Oct 7, 2016, at 10:46 PM, Damien Sykes-Lindley > <dam...@dcpendleton.plus.com> wrote: > > I cannot see any means of password protecting the database without either > buying a commercial extension to do this, or recompiling SQLite with the > authentication extension.
I’m surprised no one has mentioned SQLCipher (https://www.zetetic.net/sqlcipher/ <https://www.zetetic.net/sqlcipher/>) — it’s a free/OSS plugin that adds transparent file encryption. Since it encrypts individual pages of the file as they’re transferred between disk and SQLite’s page cache, it doesn’t affect the functionality of SQLite at all. Once you issue a ‘pragma’ statement to provide the key, the database behaves exactly as though it were unencrypted. Despite being technically a plugin, it’s distributed as a modified copy of the SQLite ‘amalgamation’ source file, I think to make it easier to build. They also have pre-built binaries for popular OSs. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
