4
Installing a custom version of SQLite3
source link: https://help.dreamhost.com/hc/en-us/articles/360028047592-Installing-a-custom-version-of-SQLite3
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Installing a custom version of SQLite3
Overview
SQLite is already installed on all DreamHost servers. You can also install your own version locally under your username. This article walks you through this process.
Installing
- Log into your server via SSH.
- Make sure you're in your user's home directory.
[server]$ cd ~
- Visit the SQLite download page to download the most recent version.
- Run the following to download it to your user's directory.
[server]$ wget https://sqlite.org/2020/sqlite-autoconf-3330000.tar.gz
- Decompress the file.
[server]$ tar zxvf sqlite-autoconf-3330000.tar.gz
- Change into the new directory.
[server]$ cd sqlite-autoconf-3330000
- Run the following to configure it.
[server]$ ./configure --prefix=$HOME/opt/sqlite
- Run make and make install to complete the installation.
[server]$ make [server]$ make install
- Add the following to your .bash_profile.
export PATH=$HOME/opt/sqlite/bin:$PATH
export LD_LIBRARY_PATH=$HOME/opt/sqlite/lib
export LD_RUN_PATH=$HOME/opt/sqlite/lib - source your .bash_profile.
[server]$ source .bash_profile
- Finally, 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 2020-08-14 13:23:32
- You can then quit the sqlite shell by running the following.
sqlite> .quit
See also
Did this article answer your questions?
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK