SQLite Browser package for ubuntu does not come with SQLCipher by default.
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
sudo apt-get update
sudo apt-get install sqlitebrowser
How could it be enabled in order to be able to view encrypted databases?
https://github.com/sqlitebrowser/sqlitebrowser/blob/master/BUILDING.md#ubuntu--debian-linux
$ sudo apt install build-essential git cmake libsqlite3-dev qtchooser qt5-qmake qtbase5-dev-tools\
qttools5-dev-tools libsqlcipher-dev qtbase5-dev libqt5scintilla2-dev libqcustomplot-dev\
qttools5-dev
$ git clone https://github.com/sqlitebrowser/sqlitebrowser
$ cd sqlitebrowser
$ mkdir build
$ cd build
$ cmake -Dsqlcipher=1 -Wno-dev ..
$ make
$ sudo make install
The solution is to build SQLite Browser with libsqlcipher-dev
package.
Here the steps required:
libsqlcipher-dev
package.sudo apt-get install libsqlcipher-dev
sudo apt install build-essential git cmake libsqlite3-dev \
qt5-default qttools5-dev qttools5-dev-tools
git clone https://github.com/sqlitebrowser/sqlitebrowser
cd sqlitebrowser
mkdir build
cd build
cmake -Dsqlcipher=1 -Wno-dev ..
make
sudo make install
This should complete without errors, giving you a binary file called sqlitebrowser
which has now SQLCipher support.