Installing a custom version of SQLite3

 

Overview

This article walks you through the process of installing a custom version of SQLite.

Installing a custom version of SQLite

SQLite is already installed on all DreamHost servers but you can also install your own version locally under your username. To install a custom version:

  1. Log into your server via SSH.
  2. Make sure you're in your user's home directory:
    [server]$ cd ~
  3. Visit the SQLite download page to download the most recent version.
  4. Download it to your user's directory using the wget command:
    [server]$ wget https://sqlite.org/2020/sqlite-autoconf-3330000.tar.gz
  5. Decompress the file:
    [server]$ tar zxvf sqlite-autoconf-3330000.tar.gz
  6. Change into the new directory:
    [server]$ cd sqlite-autoconf-3330000
  7. Run the following to configure it:
    [server]$ ./configure --prefix=$HOME/opt/sqlite
  8. Run make and make install to complete the installation:
    [server]$ make
    [server]$ 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:
    [server]$ source .bash_profile
  11. Check the version to confirm it's now being used:
    [server]$ which sqlite3
    /home/username/opt/sqlite/bin/sqlite3
    [server]$ sqlite3
    SQLite version 3.33.0 2024-04-02 13:23:32
  12. Quit the SQLite shell by running the following:
    sqlite> .quit

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?