jorgerance/accessing_sqlite3_encrypted_db.md

Created December 30, 2019 12:14

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jorgerance/dbdc65ab4e68013b125a4612a3935011.js"></script>
Save jorgerance/dbdc65ab4e68013b125a4612a3935011 to your computer and use it in GitHub Desktop.

[Accesing SQLite encrypted DB] - Using sqlcipher and sqlite3

Raw

    0 ✓ steve@hal9000 ~ $ sqlcipher jeanscollection.db
# insert password for decryption
PRAGMA key = '<PASSWORD>';
> ok
# show databases
.databases
> main: /Users/steve/jeanscollection.db
# show tables
.tables
> test_table
# insert into blue_jeans
insert into blue_jeans (name,ref) values('steve_jeans','bluejeans9000');
# quit
sqlite> .exit
0 ✓ steve@hal9000 ~ $

  