I used https://github.com/xeodou/go-sqlcipher to generate an encryped db.
sql.Open I give a key as described in the docs, and the db is generated encrypted.
I want to use a sql db browser GUI such as sqlstudio or “db browser for sqlite”, both prompt me to enter a password, but with any of the settings there (sqlcipher 3.x, 4.x or custom) Im unable to open the db.
I went to the github repo of sqlcipher and fetched sqlcipher-v4.3.0 and compiled it.
The generated sqlcipher binary is version 3.30.1, and I try to do the same:
PRAGMA key = ‘password’;
Yet the DB remains encrypted and Im unable to browse it’s data.
Any ideas? what am I missing?