How to encrypt a plaintext SQLite database to use SQLCipher (and avoid “file is encrypted or is not a database” errors)

SQLCipher SQLCipher FAQ
10

@Jolly glad to hear you got it working! As a tip, you can create a file called .sqliterc in your home directory on windows (C:\Users\username\.sqliterc) containing the PRAGMA cipher_license statement. That file is read and automatically executed each time the shell tool runs so the license will automatically be applied (and you don’t have to type or copy/paste it).

1 Like