#Installing
-
Open .bashrc file and add:
. ~/.bash_profile
-
Make sure you’re in your user’s home directory.
$ cd ~
-
Visit the SQLite download page to download the most recent version.
-
Run the following to download it to your user’s directory.
$ wget https://sqlite.org/2020/sqlite-autoconf-3330000.tar.gz
-
Decompress the file.
$ tar zxvf sqlite-autoconf-3330000.tar.gz
-
Change into the new directory.
$ cd sqlite-autoconf-3330000
-
Run the following to configure it.
$ ./configure –prefix=$HOME/opt/sqlite
-
Run make and make install to complete the installation.
$ make $ make install
-
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
-
Run the source command on your .bash_profile file.
$ source .bash_profile
- 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
- Quit the sqlite shell by running the following.
sqlite> .quit