#Installing

  1. Open .bashrc file and add:

    . ~/.bash_profile

  2. Make sure you’re in your user’s home directory.

    $ cd ~

  3. Visit the SQLite download page to download the most recent version.

  4. Run the following to download it to your user’s directory.

    $ wget https://sqlite.org/2020/sqlite-autoconf-3330000.tar.gz

  5. Decompress the file.

    $ tar zxvf sqlite-autoconf-3330000.tar.gz

  6. Change into the new directory.

    $ cd sqlite-autoconf-3330000

  7. Run the following to configure it.

    $ ./configure –prefix=$HOME/opt/sqlite

  8. Run make and make install to complete the installation.

    $ make $ make install

  9. Add the following lines to your .bash_profile. This is a file located in your user’s home directory.

    export PATH=$HOME/opt/sqlite/bin:$PATH export LD_LIBRARY_PATH=$HOME/opt/sqlite/lib export LD_RUN_PATH=$HOME/opt/sqlite/lib

  10. Run the source command on your .bash_profile file.

$ source .bash_profile
  1. Check the version to confirm it’s now being used.
$ which sqlite3 /home/username/opt/sqlite/bin/sqlite3 $ sqlite3 SQLite version 3.33.0 2020-08-14 13:23:32
  1. Quit the sqlite shell by running the following.
sqlite> .quit