sqliteubuntusqlciphersqlite-browser

SQLite Browser without SQLCipher support in Ubuntu


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

The Question

How could it be enabled in order to be able to view encrypted databases?

What Versions


Solution

  • Update

    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
    

    Legacy

    The solution is to build SQLite Browser with libsqlcipher-dev package.

    Here the steps required:

    1. First install the libsqlcipher-dev package.
    sudo apt-get install libsqlcipher-dev
    
    1. Then install requisites for building SQLite Browser.
    sudo apt install build-essential git cmake libsqlite3-dev \
                       qt5-default qttools5-dev qttools5-dev-tools
    
    1. Clone repository.
    git clone https://github.com/sqlitebrowser/sqlitebrowser
    
    1. Build steps:
    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.