Is there a linux tool to open or query sqlcipher database in the terminal?

SQLCipher
1

Is there a linux tool to open or query sqlcipher database in the terminal such as the sqlite? I am aware of DB Browser but if I have a sqlcipher db in a remote server that I want to query, what would be the best tool to use?

2

Hi @lancecontreras

You might want to take a look here:

3

Ok, we have the commercial license for sqlcipher, I checked on the zip file that I downloaded from zetetic website. There’s a sqlcipher.exe under the shell folder, but that’s for windows. Is there anything we can use for linux?

4

Hello @lancecontreras

For the Linux platform, you can compile the command line shell following these steps.

5

Thank you! I was able to compile it and run on a Linux environment!

TLDR;

$ git clone https://github.com/sqlcipher/sqlcipher.git
$ ./configure --with-tempstore=yes CFLAGS="-DSQLITE_HAS_CODEC -DSQLITE_EXTRA_INIT=sqlcipher_extra_init -DSQLITE_EXTRA_SHUTDOWN=sqlcipher_extra_shutdown" LDFLAGS="-lcrypto" 
$ make
$ sqlite3 database.db 
sqlite> pragma key = 'yourpassword'; 
sqlite> select * from yourtablename;