Installing a custom version of SQLite3

Overview

You can install a custom version of SQLite on a DreamHost server, running locally under your own username alongside the version already installed by DreamHost.

How do I install 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

• SQLite

• SSH overview

• Where is the home directory?