Compiling the latest sqlite3 on a Linux Ubuntu server

Table of contents:

Introduction

We want to use the latest version of the sqlite(3.38.0 at the time of writing) but we also want, for example, python and php to use the latest sqlite shared library as well. Since the linux ubuntu distribution doesn’t keep up with the latest releases from sqlite, we’ll have to compile from source and install the shared libraries in the system.

Downloading the source code

Compiling and installing sqlite3

Verifying that our system is using the latest sqlite3

Finally, if everything went well, we should be using the latest sqlite3 system-wide.