Compile a new sqlite3 binary on Ubuntu#

I wanted to try the vacuum into backup command that was released in SQLite3 3.27.0 on 2019-02-07.

Ubuntu 18.04.4 LTS has SQLite 3.22.0 from 2018-01-22.

Thankfully it’s really easy to compile a new sqlite3 binary on Ubuntu, using the amalgamation release.

1
cd /tmp
2
wget https://www.sqlite.org/2020/sqlite-amalgamation-3310100.zip
3
unzip sqlite-amalgamation-3310100.zip
4
cd sqlite-amalgamation-3310100
5
gcc shell.c sqlite3.c -lpthread -ldl
6
./a.out --version
7
3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837bb4d6

Now you can move the a.out file somewhere else:

1
mkdir ~/bin
2
mv ./a.out ~/bin/sqlite3

I used the backup command like this:

1
/home/simon/bin/sqlite3 data.db "vacuum into '/tmp/backup.db'"

Compile a new sqlite3 binary on Ubuntu

https://mranv.pages.dev/posts/compile-a-new-sqlite3-binary-on-ubuntu/

Author

Anubhav Gain

Published at

2024-02-02

License

CC BY-NC-SA 4.0

Syntax highlighting Python console examples with GFM

Freezing requirements with pip-tools

Compile a new sqlite3 binary on Ubuntu