Opening encrypted SQLite files

To open an encrypted SQLite .db file, you need to use sqlcipher, which you can install via sudo apt install sqlcipher.

sqlcipher app.db

# Provide the key
sqlite> PRAGMA key = 'your_key_here'

# Show tables
sqlite> .tables