[Accesing SQLite encrypted DB] - Using sqlcipher and sqlite3

accessing_sqlite3_encrypted_db.md

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 ~ $